Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you post the expression you used??
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()))
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())) )
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.
just add dimensionality() or secondarydimensionality() as a measure and check the number shown for the total row
then use accordingly