How can I add totals for each month on pivot table

[joseph_eftamand]

The totals for this pivot table are proving tricky to manipulate. Another issue is that the total price EUR-probability is grouped for each invoice of the same price. If I can get the totals for each month right then this won't be a problem. Any ideas

[sunny_talwar]

What is your expression?

[krishnacbe]

Hi,

Enable the Partial sum for MonthYear and check

[joseph_eftamand]

((win_probability)/100)*(if(currency='GBP',EachMonthAmount*$(GBPtoEUR),EachMonthAmount))

The expression calculates the adjusted value based on the probability of a win, if the currency is in GBP that is converted to EUR. EachMonthAmount is created in the script it takes the number of months between the start date and the invoice date and divides the sum into equal parts spread between the months between the two dates.

[joseph_eftamand]

I have tried that, but to no avail...

[joseph_eftamand]

[devarasu07]

Hi,

Can you share your app with mock data set?. it's easy for us to check and help you quickly. Thanks

Regards,

Deva

[sunny_talwar · Accepted solution]

Try putting Sum(Aggr()) around your expression

Sum(Aggr(

((win_probability)/100)*(if(currency='GBP',EachMonthAmount*$(GBPtoEUR),EachMonthAmount))

,YourDimensionsSeparatedByComma))

[shun_wong]

Please use Sunny Ts response, but ensure you use all the dimensions to your left, and put partial sum against your first dimension.