lea cohen
Member
Members
Forum Posts: 246
Member Since:
March 10, 2016
March 10, 2016
Offline
hello
I have here a table of data that I built in two forms
And I need a report to show me how many students there was in January, February, and more
In Table 1 it is more convenient for me to type each student in one line
But I can not make a Pivot report from him that shows me the student count every month.
In Table 2 I wrote each student 3 times in 3 months
But in the Pivot Account count one student is counted three times
And instead of showing me that in the English course there are 2 students he shows me the total amount
To create a report that will sum up a number of students each month and each course separately
How do I build a data table and what report do I create?
thany you!!
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members
Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015
Offline
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
Hi Lea
I noticed that there are difference in the Month between Table1 and Table2. Example: Chana have months June-August in Table1 but April-June in Table2. That is why your Pivottable is incorrect.
If you enter the Month similarly in both Table1 and Table2, the PivotTable will give you the answer just like what Frans Visser got using Formulas.
Hope this helps.
Sunny
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Ryan Tyree
Taza Tarwala
Ryan Tyree
Nishi Gurupersad
Tony Johlie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6871
Posts: 30101
Member Stats:
Guest Posters: 49
Members: 33662
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —