Skip to Content
avatar image
Former Member

Sorting Issue based on Val and Qty Header

Hi All,

I have cross tab report in webi based on 4 dim and 2 facts.(Val & Qty). cross tab is based on week.

I need all the val first followed by Qty. i need something like below

week1 week 2 Week 1 Week2

Val Val Qty Qty

AA xxx 1200 5600 20 55

BB yyy 900 2500 5 30

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21 at 02:18 PM

    one option is to built two cross-tab.

    First with 4 dimensions and Val measure.

    Second with same 4 dimension and Qty measure. (hide 4 same dimension and align second cross tab with first cross-tab.)

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22 at 11:45 AM

    The only way I can think they can fit in one crosstab is if you interchange row and col dimensions.

    Add comment
    10|10000 characters needed characters exceeded