Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart bar with the following data
Dimensions: Date
Expression: Sum(Sales)
I set a variable "vMax_Sales" with an input field X (6,000,000)
I would like to hide the dates that the expression is lower or equal to the "vMax_Sales" variable
There is a way to do it based on "Dimension limits" function?
how could i do it
(I tried to use
Less than, =vMax_Sales, exact amount
But for some reason the output is different than the required )
I used
Less than, =vMax_Sales, exact amount
But i can see dates with sales>=vMax_Sales
(sum(sales)>6,000,000)