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.
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!