Top function in Pivot Table

[#1]

Hi All,

Can Any One help me to apply Top or First Function to this QV Doccument.

I need all coloumns TOP Ten (10) Records in Case of FileNo ,In case of Amount no ,at every coloumn...

I sending doccument attached .......

Its very urgent

Thanx in advance

Mail me @ ......... dushyant@iconresources.com or dushyant.ntpc@gmail.com

[#2]

Hi Dushyant,

In case of Pivot Table you will not find Max Number visible. As it works only for Straight Table. Therefore you need to convert Pivot to Striaght Table to achieve this.

To achieve your requirement.

i need top 10 records based on current month amount .......................

I think that you need to use expression sorting from Sort Tab and put the desired expression like

Sum( If( Month = $(vCurrentMonth), SalesAmount ) )

and select "Numeric Value" Descending manner.

Hope, it would give you desired result.

Regards,

Raj Kishor

[#3]

Hi,

Here you are a possible solution. I hope it helps you.

Regards.

[#4]

Hi,

Here you are a better and faster solution using a calculating dimension.

Regards.