Inline table for dimension and use it in front end

Aspiring_Developer — Sat, 19 Jun 2021 11:14:29 GMT

Hello ,

I have to create below table in front end:-

Year

201801. 201802

Sales 50000. 60000

Amount. 45000. 7000

The above sales and amount are my numeric value and I have to show their sum with respect to year like sum (amount),sum(sales).

I also want to show them as dimension like above.

I think I will have to create an inline table for dummy dimensions and but I am not clear about further steps. Also ,I need to make sure that user should be able to filter out the data from these dummy dimensions.

Can anyone please help ? I am stuck .

I tried to do it using value list:-

In dimension - value list ( 'sum', 'amount')

Expression - if ( value list ('sum', 'amount')= ' sum', sum ( sales))

It worked but in this , user is not able to apply filter on the dimension .

Please help.

topic Inline table for dimension and use it in front end in App Development

Inline table for dimension and use it in front end