1 of 1 people found this helpful
I'm not sure I understand exactly. Maybe you could post a workbook (twbx file)?
However, table calculations take into account whatever is in the view, and if there is data that is filtered out it won't be included in the calculation. One way to overcome this is to create a second calculation that sets the value to either 'hide' or 'show'. Then, right click on the 'hide' section (once this calc is on the view) and select Hide. This won't actually filter out any data, it just won't show it.
Hope this helps!
I think what I'm trying to get at is figuring out how to use a constant benchmark to compare filtered values to. I'm probably not explaining it very well, but I would like to compare the sales of one event to the average sales of all events.
I hope that is clearer
you can also use a filter on a table calculation to filter the data, and the filtering with happen after the evaluation of all table calculations, something like:
This way the filter on Segment happens after computation. (just be sure a Dimension pill for Segment exists on the worksheet on a shelf other than the Filter shelf)
see the attached for a simple example.
tc filter.twbx.zip 57.7 KB
Thanks Joe, this is really cool.
I'm having a similar issue, and I'm not getting it?
I want to show the distribution of a selection, as well as a benchmark based on the total (of all data). To show different views I'm using other dimensions. The result is that the total in the benchmark will change according to the view.
How can I keep this a constant?
See attached twbx for the simple version of my request in the coffee chain example.
Can someone help me with a step-by-step procedure?
thanks a lot,
Coffee chain for benchmarks.twbx 202.2 KB