topic Re: Transform multiple measure in a dimension with modality in App Development

Transform multiple measure in a dimension with modality

chapil — Mon, 23 May 2022 14:07:51 GMT

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 — Mon, 23 May 2022 15:33:58 GMT

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

chapil — Mon, 23 May 2022 16:19:50 GMT

Yes sorry, here it is