Author Topic: Year over year calculation using Workspace advanced  (Read 526 times)

Offline AnuElza

  • Full Member
  • ***
  • Join Date: Feb 2017
  • Posts: 11
  • Forum Citizenship: +0/-0
Year over year calculation using Workspace advanced
« on: 09 May 2017 10:31:11 am »
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.


Offline hespora

  • Statesman
  • ******
  • Join Date: Nov 2015
  • Posts: 381
  • Forum Citizenship: +22/-0
Re: Year over year calculation using Workspace advanced
« Reply #1 on: 10 May 2017 02:30:27 am »
if you have access to report studio, then create in report studio, save, and have the user open in WSA. works just fine.

Offline AnuElza

  • Full Member
  • ***
  • Join Date: Feb 2017
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Year over year calculation using Workspace advanced
« Reply #2 on: 10 May 2017 09:37:59 am »
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.

 


       
Twittear