Forum Discussion
Anonymous
8 years agoNot applicable
Difference between two columns in matrix visualisation
Hi, I have in a matrix a row with two columns. Row is company name, and columns are 201806 en 201807 I can make a total (setting a subtotal), but how to make a difference? Example: Company 20...
- Anonymous8 years ago
HI Anonymous,
Please try to use below formula to replace amount column and drag it to value field. then you will find diff effect apply on total level.
Diff = IF ( ISFILTERED ( Table[Date] ), SUM ( Table[Amount] ), CALCULATE ( SUM ( Table[Amount] ), VALUES ( Table[Company] ), Table[Date] = 201806 ) - CALCULATE ( SUM ( Table[Amount] ), VALUES ( Table[Company] ), Table[Date] = 201807 ) )Regards,
Xiaoxin Sheng
Anonymous
6 years agoNot applicable
I have 4 columns in my visualization.
1. Value of X
2. % of X [value of X/sum of column total]
3. Value of Y
4. % of Y [value of Y/Sum of column total]
Both X & Y are from different table.
My goal is to calculate the difference between % of X & % of Y in % POINTS.
Has anyone been able to figure it out yet?
Thanks in advance.