Forum Discussion
Ignoring filter context / summing items from different filter contexts
Hey there, I am having trouble visualizing Balance Sheet. In my report I have two separate matrix tables for visualizing Current Assets and Current Liabilities. The problem that I am facing i...
It will get me the desired result if I remove the filter context from the matrix from "only show items that belong to Current Liabilities" to "show items that belong to current liabilities and Income Statement". After that it will also map out all the accounts that belong to the Income Statement to the matrix and that's something I would not like do.
With these calculations the filter contexts collide if I simply add em up and therefore will not give me the correct result.
I can post you sample picture later on if this doesn't help you.
Anonymous
If I understood correctly you are using Internal Filters using Filters PANE , what i Suggest use Slicers (external filters) to get your desired result