Running-total in crosstab column for each Month across columns

[Starfish2201]

Hi Gurus,

I have requirement where I need to show Actual Count and Cumulative Count for every month in Columns. I am using Running-Total for cumulative count, but I am not able to get this done for 3 set of rows getting repeated across rows. Please see below.


             Jan               Feb          Mar   

         Count Cumulative   Count Cumulative   Count Cumulative
         ----- ----------   ----- ----------    ----- ----------
         
    Director   4   4      2   6      3   9   

Company  Manager       10   10       1   11       8   19
   
    Sr Manager     5    5      7   12      9   21

I tried using crosstab, I tried creating a list and then pivot it to crosstab, but I have not been successful.
Please help in providing any pointers.

Thanks a lot for your help and guidance !!!

[BigChris]

Does it have to be a crosstab? You could perhaps get the results you're after by calculating the values for each month, but it would mean setting them up for each month. You could then have some conditional formatting to only show those columns that relate to months that have already passed...

E.g.
JanCount = if([Month] = 'January') then (count([Data Item])) else (0)
JanCumulativeCount = JanCount
FebCount = if([Month] = 'February') then (count([Data Item])) else (0)
FebCumulativeCount = FebCount + JanCount
etc.

Hope that makes sense

C

[Starfish2201]

Hi BigChris,

Thanks for your response !!!

I am using a crosstab because I need the counts for Director, Manager and Sr Manager to be shown in a row. And Director, Manager and Sr Manager keeps repeating for Company1, Company2, Company3 and so on.

Would it be possible using a list? Can you please give me some pointers?

Thanks Again!!!