Always last rows

[Chanty4u]

     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?

[its_anandrjs]

Create a order table like

Order:

LOAD Month,

     Order

FROM

(ooxml, embedded labels, table is Sheet2);

Regards

Anand

[Chanty4u]

Hi Anand,

I didn't  get your input ?  could you please explain?

[its_anandrjs]

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

[Chanty4u]

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?

[its_anandrjs]

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

[Chanty4u]

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.

[its_anandrjs]

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

[Chanty4u]

Issue resolved Anand thanks