Measure as dimension and calculate a another measure

[marishnagendran]

Dear All,

Date	Product	Product_Type	Qty	Gross Profit	Net Profit	Marigin
11-Jun	A	Test	10	10	8	2
11-Jun	B	Test	20	20	15	5
11-Jun	C	Test	100	30	20	10
11-Jun	D	Test	80	15	10	5
11-Jun	E	Test	40	20	5	15

My OutPut:

Dimension	Net Profit
0-50	28
50-100	30

0-50 & 50-100 is Qty

Is it possible?

[dplr-rn]

simplest is to create your dimension while loading the data.
e.g.
if( quantity<=50, '0-50','50-100') as NewDimension

and use that in your table.

Hope i understood the issue clearly

[marishnagendran]

In Front-end i want to do this