Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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?
Create a order table like
Order:
LOAD Month,
Order
FROM
(ooxml, embedded labels, table is Sheet2);
Regards
Anand
Hi Anand,
I didn't get your input ? could you please explain?
Load your data this ways
Data:
LOAD Month,
Region,
Sales,
Year
FROM
(ooxml, embedded labels, table is Sheet1);
Order:
LOAD Month,
Order
FROM
(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.
Regards
Anand
Hi anand,
Thanks for your input. But what is Order? can you explain this? what it will do? how the output delivered?
can you explain?
I generate one order table with order sequence for month field
Month | Order |
apr | 1 |
jul | 2 |
may | 3 |
jun | 4 |
mar | 5 |
dec | 6 |
jan | 7 |
Note:- Also how you decide the sequence of this Month table let me know.
Regards
Anand
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.
Good night.
Thanks Ok,
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.
SortOrder:
LOAD * Inline
[
Month,OrderSeq
feb,1
mar,2
apr,3
may,4
jun,5
jul,6
aug,7
sep,8
oct,9
nov,10
dec,11
jan,12
];
Regards
Anand
Issue resolved Anand thanks