calculated dimension issue

[Anonymous]

hi gurus,

i have a dimension like media, under media f1,f2,f3,f4  are the fields

revenue is the target calculation

Problem :

sum(f1,f2,f3) = revenue of r1

sum(f4) = revenue of r2

how to break the total reenue as r1 , r2 revenue

plz help me out.

thanks

[kaushiknsolanki]

Hi,

     Put calculated dimension as

     =if(wildmatch(Media,'F1','F2','F3'),'R1','R2')

     Give lable as Rvenue

      And add expression as Sum(Rev)

      For more info have a look at the application

[Anonymous]

hi kaushik,

r1 and r2 are sharing the X axis when i turned to line chart

i want to dispay separately in line chart

plz help me to achieve the same

[kaushiknsolanki]

HI,

    Do you mean you just want only points to be displayed instead of join. Something like shown in the below pic.

      If yes then go to expression in Display options remove the Deselect the line and select the symbol.

Regards,

Kaushik Solanki

[Anonymous]

hi koushik,

Separate line  for r1 revenue and r2 revenue  from x axis

if i take month Also As dimension

[kaushiknsolanki]

Hi,

     Keep month as first dimension and Revenue(Calculated Dimension) as Second dimension.

Regards,

Kaushik Solanki