i have strange issue.
i have data like below attached and
the result in pivot table ....... should be always 5,6th record should go to bottom lines.
PFA. sample excel with input and output.
in my data dec,jan rows should come bottom
Can anyone help me on this?
Load your data this ways
(ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is Sheet2);
Note:- But what about the May that is also come last in your out put for more please see the attached qvw or please explain more.
I generate one order table with order sequence for month field
Note:- Also how you decide the sequence of this Month table let me know.
thanks Anand. that we need to check currently user need to see the data 5,6 th record should be in last row.
will update you once i got clear info.
One way also if you need only the dec and jan should always be last two rows then try to load sequence table into the data model and connect it with the Month field and in front end with chart do make some changes on the sorting order.
LOAD * Inline