Skip to Content
0
Former Member
Jul 26, 2016 at 02:45 PM

Cross tab - sorting & totals

607 Views

WEBI 4.1

UNX

I have 3 fields from universe

[Report Year] = [2016,2015,2014,2013] - datatype Numeric

[Report Month] = [1,2,3,4,5,6,7,8,9,10,11,12] - datatype Numeric

[Profit]

[Product]

I have a cross tab as below

Need to implement 2 things

  1. Total column which will show profit for each year/product if the report is ran for more than one year
  2. I want to show the year and month in descending order starting with 2016 March to Jan 2015 first as shown in example below