Calculated Dimension in Bar chart

[#1]

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))

[chrismarlow]

I am not sure I follow. Is 'CategoryName' in your table with CompanyID & Amount, in which case your inline table won't join properly, you would need to get the possible CategoryNames for NICO and include in your inline.

[MK_QSL]

Try

=If(IsNull(CategoryName),

     SUM({<CompanyID={'C0,'c1','C2'}>}Amount),

     SUM(Amount)

)

[#4]

NICO is not a Category but still i want this to be appear in Chart, That's why i created a calculated dimension

[#5]

No, It's not displaying. Instead of giving SUM({<CompanyID={'C0,'c1','C2'}>}Amount), I tried giving one value "50.16". That time, It shows the value for Report_Month = null value. but not showing for other report months.

[MK_QSL]

Can you provide sample apps please?

[chrismarlow · Accepted solution]

I am still struggling with exactly what you need. If you simply want to reclassify those 3 CompanyIDs as NICO then I think the attached might be a step towards that.

[#8]

See if this works. sum({<CompanyID={'C0,'c1','C2'},Category=>}Amount)

[manojkulkarni]

not getting exactly to your problem. can you upload your app here.

[Anonymous]

sum({<Category={'NICO'},CompanyID={'C0,'c1','C2'}>}Amount)