Apply Rank in PIVOT Table

Question

Hi,

Can I apply rank for a particular fact by a dimension in the pivot table.

For example I have a fact column called as 'SALES'

and I have 'Emp_code' and 'Item_type' as dimensions

I want to create a pivot table and need is o apply rank on the sales column which is pivoted by 'item_type'

Regards....

3018071 · Answer

ok

I got this Thomas

can you sort the rank column fro here
I mean ascending or descending???

Thomas Dodds · Answer

Firstly:  Rank(any fact) is not a dimension ...

Notice I did the rank of revenue by the sales rep type ... so the total revenue across all rep types produces the ranking for the product types.  Then I just moved that fact column tot eh row beside the product type dimensional attribute in the pivot table.

3018071 · Answer

how can u apply sorting on the rank
and keep rank as dimension like product here.
and keep product as a pivot dimension(like product type) here.