Variance in Pivot Chart

[vsharma1]

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

[vsharma1]

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

[vsharma1]

[vsharma1]

sorry this one is correct

[ramasaisaksoft]

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

[vsharma1]

Hi,

below expression is returning 0

  Count({<[PreviousYTDComp]={'YTD 2018'}>}Claimnumber)

[vsharma1]

expression is returning value no

I have implemented difference of two expression based on year but it is giving me only one value