Crosstab without Multiple Queries

building reports webintelligence
1

Can anyone tell me if there is a way to create a crosstab report with a products column on the left side and a string of month-end dates in the row at the top of the crosstab using only one query? When I put the total products items measure in the crosstab when I insert a difference column comparing one month to the previous month it creates columns after each products items month column. I am trying to measure the difference sold from one month to the other and put it into one column. I know this can be done using mutiple queries, however, I only want to use one query to create this report. :crazy_face:

usjse :us: (BOB member since 2008-01-21)

2

There are two ways.

  1. You have to create a measure object for each month by just hard coding the month name. So you need to create 12 objects and header can be harcoded and you can insert the difference clomun after every two months. Draw back is … Some lenghty process
  2. You can calculate delta value at the end. Then you don’t need to create that many measure objects.

madhu kothamasu :us: (BOB member since 2007-07-31)