Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem that I can't solve. I have a table made up of:
| date | Country | ValueDimension 1 | ValueDimension 2 |
I want to represent on a graph, for each country, the daily difference of the sum of ValueDimension1 and ValueDimension2
(ValueDimension1 [Day 2] + ValueDimension2 [Day 2] - {ValueDimension1 [Day1] + ValueDimension2 [Day1]}
I have tried with:
sum (ValueDimension1) + sum (ValueDimension2) - (Above (sum (ValueDimension1) + sum (ValueDimension2)), 1)
but what it creates is an "unordered" difference. How can I solve it?
Thank you all
I'm sorry for that but I tried the solution.
In the "Measures", there is an option to calculate the expression: the modificator. In the option there is "difference".
I'm sorry for that but I tried the solution.
In the "Measures", there is an option to calculate the expression: the modificator. In the option there is "difference".