Pivot table sort order

[polisetti]

Hi I have a pivot table in which i am having expressions like  Market Rx,Market share and Decile for different brand.In which the Market Rx is same for all the brands.So I dont want to show Market Rx for every brand.So i want to show Market Rx expression seperate of that group of expressions.

I want show like this ...Can it be possible in pivot table?

Header 1	Header 2	Header 3	Header 4
	Brand	ABC	DEF
	Market Rx	Market share                   Decile	Market Share                        Decile
	24	334                                  D1	123                                        D2
	50	234                                  D1	454                                        D2

Please check screen shot....

[chiru_thota]

Hi ,

It is not possible directly.

May be you can try to make Market Rx as calculated dimension.So that it won't repeat for each brand.

Thanks,

Chiru

[polisetti]

Ya i tried it ,but it is showing error in calculated dimension.As in market Rx i used a set analysis and it is a complex expression .I think it will not work in calculated dimension.

[sujeetsingh]

As per my knowledge the pivot table first do sorting on dimension and then expressions

[sundarakumar]

Plese post the expression(calculated dimension) , i think it should work..

-Sundar

[polisetti]

Ok just try this...

If

(IsNull(SUM(TOTAL<[Customer Name]> {<[_Time Bucket Type]={'CURR'},[Brand Name]=,[Astellas Brand]=>}[XPO Product Sales])),'',
(SUM(TOTAL<[Customer Name]> {<[_Time Bucket Type]={'CURR'},[Brand Name]=,[Astellas Brand]=>}[XPO Product Sales])))

[chiru_thota]

Can you share your application if possible ?

So that I can try some thing.

Thanks,

Chiru