I had a search and could not find anything that was helpful so here we go...
We use a filter to remove data with a certain tag (Tag A). This works as intended because we don't want the data tagged Tag A included in the charts. However; we DO want to display a 'footnote' (I assume in the form of a text object...) that will display the total for data tagged as Tag A.
This is quite a pain because we can't get around the sheet filter for a single object.
Note: Coding the current charts to filter out Tag A is not an option we want to pursue because it would be days of work to modify all current expressions across multiple tabs.
You could use Set Analysis to override any selection for a particular object. For example you could use following to show in the textbox for a footnote, which will INCLUDE records of all Tags:
='Total Sale= ' & sum({$<Tag=>} TOTAL NetSales)
By specifying Tag= (nothing after =), it supresses any selection made for that field (Tag, in this case).
Hope this helps you. Otherwise, an example QVW would be helpful to show what you are trying to do.
You could use Set Analysis to override any selection for a particular object. For example you could use following to show in the textbox for a footnote, which will INCLUDE records of all Tags:
='Total Sale= ' & sum({$<Tag=>} TOTAL NetSales)
By specifying Tag= (nothing after =), it supresses any selection made for that field (Tag, in this case).
Hope this helps you. Otherwise, an example QVW would be helpful to show what you are trying to do.
