Skip to Content
0

Sorting Issue based on Val and Qty Header

Feb 21 at 11:37 AM

20

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Feb 21 at 02:18 PM
0

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.)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Thanks for that. can't i use i a single cross tab

0
Kuldeep Ghosh Feb 22 at 11:45 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded