click on the green sum([Number of Records]) pill>quick table calculation>Difference. If that does not automatically do what you want, click on the pill again> Edit Table Calculation. An interface will come up where you can manipulate what is being considered in terms of difference from what, and which dimensions to partition along.
Thanks for reply. So my records are date driven, so I have to use dates to sum records. So these are the two LODs I built:
This is for the First Date:
This is for Current Date:
But when I try to create the difference I am getting an error?
Is this a cause of me using a date?
Justin, thank you as well for the Reply - I tried what you provided, but I need to be able to see both columns of data and a third column with the difference. Your methodology won't do what is needed.
Diff=SUM[First Date]-SUM[Last Date]