Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have the following data:
may I be directly plotted to the difference between the two data?
Thanks
HI
Yes,
= Cost2 - Cost1
or
=Sum(Cost2)- Sum(Cost1) if you have any other field related..For ex:
ID,Cost1,Cost2
1,345,3456
1,34,26
2,45,75
2,567,987
In this, Cost2-Cost1 not suits, so use Sum(COst2)-Sum(Cost1) as expression and ID as dimension