Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
but client want to see the chart as per the attached image.So I have to take pivot table only.
Since you have fixed expression list you could add this format in straight table rite ??
We can get this format in straight table.
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