Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My pivot table doesn't Show correct totals. This is My Set analysis
if( Level1 = 'Inflow',
sum(Amount),if( Level1 = 'Outflow',
(sum(Amount)*-1),sum({<Month={"$(=MaxString(Month))"}>}Amount)))
But Total is not correct. Can you please give me any suggestions or ideas.
what are the dimensions? Is month a dimension of the pivot table as well. As suggested already , please post a sample as well which w can look at.
f( Level1 = 'Inflow',RangeSum(Above(Sum(Amount), 0, RowNo())))
try if you look for totals
This is how it looks now and I want that total to be actual total of what is written in this rows.