topic Re: Display top 10 records on Pivot table and line chart in App Development

Display top 10 records on Pivot table and line chart

pani — Fri, 15 Nov 2024 21:13:52 GMT

Hi all,

I have sales data file contains Store, Product, order, id, Time_period(1week, 1month, 3Month) information. Need to display top 10 orders sales details Time_period wise( 1Week, 1Month, 3Month) in Pivot and Line chart.

when I tried, data is getting summing up at product level but need to show top 10 sales records at order level.

Please advise.

Re: Display top 10 records on Pivot table and line chart

Anil_Babu_Samineni — Fri, 24 Nov 2023 20:03:33 GMT

Can we have dummy data to understand more?

Re: Display top 10 records on Pivot table and line chart

sidhiq91 — Sat, 25 Nov 2023 05:24:32 GMT

@pani Could you please provide some sample data?

Re: Display top 10 records on Pivot table and line chart

pani — Sat, 25 Nov 2023 09:56:14 GMT

Thanks Anil and Sidhiq for your response, I am able to resolve it by giving ranking using auto number in script. Can I ask you u similar kind of question that I want to create two tables, one is for sorting ascending order and another table for descending order using below inline table, when i tried the second table behaving like table1(FinalTable) even I changed orderby to desc to 2nd table(FinalTable1). please suggest.

Table:

LOAD * INLINE

[

MONTH, SALESMAN, SALES_VALUE

201501, BEN, 10

201501, ANN, 20

201501, JAC, 5

201502, BEN, 100

201502, ANN, 20

201502, JAC, 50

201503, BEN, 5

201503, ANN, 20

201503, JAC, 1

];

FinalTable:

LOAD *,

AutoNumber(SALES_VALUE, MONTH) as RANK

Resident Table

Order By MONTH, SALES_VALUE desc;

FinalTable1:

QUALIFY*;

LOAD *,

AutoNumber(SALES_VALUE, MONTH) as RANK

Resident Table

Order By MONTH, SALES_VALUE asc;

DROP Table Table;