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.
if you have access to report studio, then create in report studio, save, and have the user open in WSA. works just fine.
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.