Total for Count in Pivot table

[#1]

Hi,

Can somebody tell me how to change the formula to sum all rows in this pivot table?

Thanks

MonthYear	Count({$<Year = {2010}>} DISTINCT No.C)
Jan-2010	39
Feb-2010	42
Mar-2010	42
Apr-2010	52
May-2010	52
Jun-2010	52
Jul-2010	52
Aug-2010	52
Sep-2010	52
Total	52

[johnw · Accepted solution]

I believe this:

sum(aggr(count({<Year={2010}>} distinct No.C),MonthYear))

[#3]

Thanks a lot John.

[#4]

Hi,

i am new in qlikview system.Please help me regarding my concern.

Can anybody tell me what should be the exact formula?

The delivery qty.and quantity reduced should be the same quantity.The formula of delivery quantity is correct.

This is my formula - Sum (DISTINCT ([QUANTITY REDUCED]))

Please see attached file.

The table should be like this.

DELIVERY  QUANTITY	QUANTITY REDUCED
2	2
1	1
1	1

Thanks a lot.