topic Re: Pivot Table Totals giving Zero in App Development

Pivot Table Totals giving Zero

Kritika_Dhanbhar — Mon, 19 Dec 2022 22:53:55 GMT

hello,

I have certain calculated columns for YTD by month. When I am enabling the Pivot table totals it shows the correct values for columns that do not need YTD but zero for the columns using an expression for YTD. Any idea why is this happening?

I have used functions above(),sum(),RowNo() for calculating YTD

Thanks

Re: Pivot Table Totals giving Zero

vinieme12 — Tue, 20 Dec 2022 04:14:18 GMT

can you post the expression you used??

Re: Pivot Table Totals giving Zero

Kritika_Dhanbhar — Tue, 20 Dec 2022 05:07:17 GMT

for 2nd and 3rd col it is: RangeSum (above(sum([collected gallons]),0,RowNo()))-----(col is different for 3rd but expression is the same)

for 4th col: RangeSum (above(sum([collected gallons),0,RowNo()))-RangeSum (above(sum([Strt_Collec]),0,RowNo()))

Re: Pivot Table Totals giving Zero

vinieme12 — Tue, 20 Dec 2022 07:03:04 GMT

this is a cumulative sum ! why would you total a cumulative sum ??

you might just show actual YTD using dimensionality()

= if( secondarydimensionality() =0

, sum([collected gallons]) //on total row

, RangeSum (above(sum([collected gallons]),0,RowNo())) )

Re: Pivot Table Totals giving Zero

Kritika_Dhanbhar — Tue, 20 Dec 2022 08:02:13 GMT

Correct, I want to display the final YTD, I tried it using secondarydimensionality() but the problem is all the columns have secondarydimensionality=0 so it just shows the same value for all columns.

Re: Pivot Table Totals giving Zero

vinieme12 — Tue, 20 Dec 2022 08:29:19 GMT

just add dimensionality() or secondarydimensionality() as a measure and check the number shown for the total row

then use accordingly