set analysis

[bhavvibudagam]

Hi,

In a pivot table I have two dimensions Hour and Weekday.

In the expression i need to put this if logic

=if(LWCHRG.OPPD_PERS_PROP='PERSONS',COUNT({<CHRGCNT={'1'},NAME_CODE={'VI'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT),

if(LWCHRG.OPPD_PERS_PROP= 'PROPERTY',Count({<CHRGCNT={'1'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT),

if(LWCHRG.OPPD_PERS_PROP= 'SOCIETY',count({<CHRGCNT={'1'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT))))

But I cant take LWCHRG.OPPD_PERS_PROP as a dimension in my table. so i am not getting any thing in table.

Is their any way to put this expression in the pivot table without dimension LWCHRG.OPPD_PERS_PROP.

Please help me to do.

Thanks

[avinashelite]

I don't think it would be possible , you need a metric upon which the calculation need to be done , you could try with the straight table you will get the option to hide the dimension

[miguelbraga]

Hey there,

Can you specify further your issue giving us a sample data and the expected output I couldn't understood your problem.

Best regards,

D.A. MB

[bhavvibudagam]

but client want to see the chart as per the attached image.So I have to take pivot table only.

[avinashelite]

Since you have fixed expression list you could add this format in straight table rite ??

[varshavig12]

We can get this format in straight table.

[gilbertomedeiro]

Hi Bhavvi,

If I understand your issue, you need keep the pivot table without dimensions and sometimes you need to change this pivot table in a pie chart, for exemplo, is not it? So, If am I right, you should do that in your application. Take a look in a sample attached.

I hope it's solve your problem!

Regards,

Gilberto