How to Calculate % for a TopN records

3427576

Hi,

I want to calculate percentage for a column which is picking TOPN records in a column.

I have a column called AP Amount from which I am picking top 10 records by using TOPN function. I created another calculated measure called % AP Amount in which I need  percentages in this column with respect to the AP Amount. Please guide me how to achieve this.

Thanks

Pedro F

Just add a duplicate layer column of AP Amount and select show data as percent of column.

3427576

Thanks Mate !!

You made my day...been working on this over a week.

3427576

An extended question...

How to customize the column names, as  both the columns are representing the same names. Just like Revenue in your screenshot.

[Deleted User]

Format Headings

3427576

Hi,

How to reflect/pass the data in the duplicate layer to the graph or to a column which can influence the graph. The value in the % Overdue to Total is being calculated on a whole but I want only for TOPN.

Please notice the difference in values for the same AP Overdue Amount.

Thanks

asim cholas

Hello,

In the same pivot table you will find an option to create chart at the end. Use it and select line bar. It will work.

3427576

Thanks!!

How could I add It to the view, where a drop down will be provided to select between graph or table.

[Deleted User]

View selector