Transform multiple measure in a dimension with modality

[chapil]

Hello guys, 

I have a dataset with multiples dim & measure.

My measure are :

AMOUNT_M1 (200$) | AMOUNT_M2 (400$) |  AMOUNT_M3  (100$)

I would like to transform this in a dimension to do a pie chart. 

With my dimension TIME : >30days | >60_days | > 90days 

And my measure VALUE : Sum(AMOUNT_M1 ) | Sum(AMOUNT_M2) | Sum(AMOUNT_M3)

I can't do it line by line cause my dataset is already aggregate, do you have a solution for me ?

Thanks a lot 

[vinieme12]

Please post some sample data and mock up of expected.output in excel

[chapil]

Yes sorry, here it is