Totals not working in pivot table

[paul_ripley]

Hello

I have a table that shows 643 when I just show bud2_line and costc in the pivot table and straight table.

I know this value should be 752

When I add an extra dimension 'text' to the straight table which shows individual lines then the total suddenly becomes the correct number

The pivot table still shows the wrong number ie the individual rows add up to 752 in the pivot table not 643

This is the expression

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {">0"},
DataSource = {"Agresso"}
>} $(vCurrency))

Could you please help me understand why

a) the straight table total only works with the Text dimension added

b) why the pivot table doesn't work at all even when I add the text

Many thanks

Paul

[sunny_talwar · Accepted solution]

Try this may be

Sum(Aggr(

Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, bud2 = {">0"}, DataSource = {"Agresso"}>} $(vCurrency))

, bud2_line, text, costc))

[paul_ripley]

Hi Sunny

Thanks so much for your help, that worked!

Paul