App Development

[usr1]

I have a custom dimension for a chart where I want to display the dollar amount for a certain cost codes within a subset of types. This dimension works EXCEPT when I try to filter on either the code or type from a filter. 

Example: 

sum({<TY_LY={'TY'},[Code]={'A','B','C','D'},[Type]={'1','2','3','4'}>}[Dollar Amount])

Lets say that the above formula totals $100; and each Code equals $25, if the user selects 'A' from the code filter I would expect that the total would then equal $25 BUT it does not change. 

Any help would be much appreciated. Thanks! 

[vinieme12 · Accepted solution]

Try as below

sum({<TY_LY={'TY'},[Code]*={'A','B','C','D'},[Type]*={'1','2','3','4'}>}[Dollar Amount])

[usr1]

Thank you that worked perfectly! 

[vinieme12]

Great 🙂 , kindly close the thread by accepting the response as "Solution"