Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is the scenario:
Product (dim), Sales (dim), | Plan(dim), | Sales - Plan (expression - calculated within the Straight Table) |
A, 1000, | 800, | 200 |
B, 300, | 800, | -500 |
C, 100, | 50, | 50 |
D, 5000, | 2000, | 3000 |
I have a slider object on the screen with Min and Max variables to filter the (Sales - Plan) range.
Is it possible to have a filter on an expression (Sales - Plan) within the straight table? If yes, how do I implement.
Thanks in advance!
Have you tried something like this as expression
=If(Sales-Plan >= vMin and Sales-Plan <= vMax, Sales-Plan)
If the 'supress zero values' is enabled on presentation tab, it should filter your chart accordingly.