Measure in column in pivot visual

[Anonymous]

Hi every one,

thanks inadvance for your help.

I have two measures and a column named "Rolling 12 month adviser segment" and "Adviser Count" as  measures and adviser state as a column that I want to show them in a pivot table. but the table's not filterd by "Rolling N month adviser segment" and also I can't put it in column in the pivot table. please see my measures and pivot table:

Rolling 12 month adviser segment= IF (
 [SVR Factor] < 0.5,
"Prospect",
IF (
[SVR Factor] >= 0.5
&& [SVR Factor] < 3,
"Grow",
IF ( [SVR Factor] >= 3,"Nurture", BLANK () )
)
)
Adviser Count = DISTINCTCOUNT('FUM- Flow'[ADVISOR_BK])
I need to have a pivot table that show Rolling 12 month adviser segment like bellow:

Adviser State	Nurture	Prospect	Grow
NSW	233	240	260
SA	1085	1200	800
VIC	79	120	280
QLD	803	950	100

Thanks,

[wdx223_Daniel]

select Metrix visual and put the calculate column in the column area

[Anonymous]

Thanks. I've tried but not worked