Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I wnat to create a chart with two dimensions(Report Month, Category) , Category contains one calculated Value (NICO)
Now Dimensions are : Report Month
Category_Name(Dispute, Legal Dispute, Collectible, NICO --> Calculated value in Script as below)
For the calculated dimension i created a dummy Dimension at backend by using Inline function
Load *Inline[
CategoryName, Category
Dispute, Dispute
Legal Dispute, Legal Dispute
Collectible, Collectible
, NICO
];
So by this i can able to get the NICO in Category. But the problem arises while assigning a value for NICO.
Expression used :
=if(Category='NICO',sum({<CompanyID={'C0,'c1','C2'}>}Amount),sum(Amount))
It seems, it is working. Some of the companies will fall under "NICO" Criteria. So I want to show them in Seperate Stack of Bar. As you Said if(match(CompanyID,'C0','C1','C2','C3'>0, "NICO',CategoryName) is parfectly working as i want.
Hope it is understandable. Soon i will post .qvw file with some sample data
Hi Team,
I have added a sample report for better understanding. Hope it helps...
Thank you for your help