Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate variance as shown below in pivot chart
2018 | 2019 | Variance | |
Business Segment | |||
Textile | 400 | 300 | -100 |
Food | 250 | 300 | 50 |
Insurance | 220 | 180 | 40 |
it should be like below
2018 | 2019 | Variance | ||
Business Segment | ||||
Textile | Sales | 400 | 300 | 100 |
NoCustomers | 23 | 24 | -1 | |
Budget | 212 | 112 | 100 | |
Food | Sales | 250 | 300 | -50 |
NoCustomers | 28 | 22 | 6 | |
Budget | 156 | 124 | 32 | |
Insurance | Sales | 220 | 180 | 40 |
NoCustomers | 54 | 21 | 33 | |
Budget | 465 | 422 | 43 |
sorry this one is correct
Hi Sharma,
we can create the difference/Variance between expressions in different ways
Way 1: Create a new expression , write 2018 expression- 2019 Expression
Way 2: Create new Expression , write down the title of "2018" expression Name (Which one is - write down the title of "2019" expression Name
Hi,
below expression is returning 0
Count({<[PreviousYTDComp]={'YTD 2018'}>}Claimnumber)
expression is returning value no
I have implemented difference of two expression based on year but it is giving me only one value