Pivot Table Totals is Incorrect

[mariamovasheli]

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.

[agigliotti]

could you show your actual and desired result?

[pradosh_thakur]

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.

[Channa]

f( Level1 = 'Inflow',RangeSum(Above(Sum(Amount), 0, RowNo())))

try if you look for totals

[mariamovasheli]

This is how it looks now and I want that total to be actual total of what is written in this rows.