Year over year calculation using Workspace advanced

[AnuElza]

Hi,

I have a simple crosstab with Order Method, Year and Quantity. I need to compare the quantity difference between years, say 2013 quantity- 2012 quantity. Or % difference between years.
I tried to do it, but in workspace advanced I am not getting that option.
I am trying to resolve this for business user who doesn't have access to Report studio.
Any help would be highly appreciated!.

Thanks.

[hespora]

if you have access to report studio, then create in report studio, save, and have the user open in WSA. works just fine.

[AnuElza]

Thanks hespora.

yeah, that's what I am going to do. But I was hoping to do it in CWA, so business user doesn't have to come to IT for a basic requirement like this.
I figured out a way to do it in CWA though, but works with measures with 'total' aggregate property. The original requirement is Customer Cnt column which has 'Count Distinct' as aggregate property.
I couldn't get that to work. I guess I would have to do that in report studio.

Thanks again.