Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I've got a pivot table with an expression (below) that includes a variable linked to a slider.
So when I increase/decrease the variable in the slider it then changes the value in my pivot for the respective line in the pivot table. This works perfectly, however the Totals (partial sums) do not update with the change in variable.
Any help appreciated.
Thanks
=IF(%Identifier=1,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%1/100,
IF(%Identifier=2,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%2/100,
IF(%Identifier=3,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%3/100,
IF(%Identifier=4,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%4/100,
IF(%Identifier=5,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%5/100,
IF(%Identifier=6,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%6/100,
IF(%Identifier=7,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%7/100,
sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers))))))))
What are you chart dimensions? May be try this
Sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}Aggr(
IF(%Identifier=1,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%1/100,
IF(%Identifier=2,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%2/100,
IF(%Identifier=3,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%3/100,
IF(%Identifier=4,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%4/100,
IF(%Identifier=5,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%5/100,
IF(%Identifier=6,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%6/100,
IF(%Identifier=7,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%7/100,
sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers))))))))
,ChartDimensionsHere))
What are you chart dimensions? May be try this
Sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}Aggr(
IF(%Identifier=1,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%1/100,
IF(%Identifier=2,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%2/100,
IF(%Identifier=3,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%3/100,
IF(%Identifier=4,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%4/100,
IF(%Identifier=5,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%5/100,
IF(%Identifier=6,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%6/100,
IF(%Identifier=7,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%7/100,
sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers))))))))
,ChartDimensionsHere))
That's brilliant, thanks for your help.