Reverse of Bucket

[Srinivas]

Hi anand,

i want all different buckets make into one Dimension.

Please find below excel.

i want like this way

Please help on this ...

Regards

Munna

[lironbaram]

hi

have a look at the attach extension

[its_anandrjs]

Sorry for late response but it is not the right way of loading this tables any way what is the reason for loading fields this way, See the script below

CrossTable(AgeBucket, Data,1)

LOAD 1 as DUMMYFIELD,

     [1-30 Days],

     [31-60 Days],

     [61-90 Days],

     [91-120 Days],

     [121-360 Days],

     [Over 360 Days]

FROM

[Days.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Srinivas · Accepted solution]

Thanks a lot Liron,

it's fine.

Thanks

Munna