Calcucion Difference % between total of two columns

[former_member355106]

Hello together,

We are using a Live Data Connection. Inside the story we would like to calculate the difference of the total of two columns in percent. There exists the possibility to do this if applied to cells of the same column but not between different columns:

The calculation should apply to these cells:

BR/

[VijayetaSharma]

Hello oliver76,

You need to use cross calculations with grand total % function in caclcuated measures.

Thanks,

Vijayeta

[former_member355106]

Hi Vijayeta, are we are using Live Connections Cross Calculations are not supported. Is there something else we can do here?

[VijayetaSharma]

I didn't realized you mentioned live connection. In that case you can get around this limitation by using Restricted Measure for existing columns and then a calculated measure for totals at the end.

Thanks,

Vijayeta

[former_member355106]

Hi Vijayeta, thank you. Could you please give me a hint how can I create the restricted measure?

I need to calculate the pecentage diffenrence betwen these two columns:

Q1/2018 Q2/2018 Q4/2018

Value 1 Value 2 Value 3

%Difference %Difference

between value between value

1 and 2 2 and 3

BR/