Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Did you mean:
Creator III

Totals not working in pivot table

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))

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

1 Solution

Accepted Solutions
MVP

Try this may be

Sum(Aggr(

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

, bud2_line, text, costc))

2 Replies
MVP

Try this may be

Sum(Aggr(

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

, bud2_line, text, costc))

Creator III
Author

Hi Sunny

Thanks so much for your help, that worked!

Paul

Community Browser