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.