Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to display a single row of a chart where an expression value equals a stated value?
Example: I have the following chart with the 1 Dimension and 4 Expressions. The Total Pct expression is the same as the Pct expression except that it has the "Full Accumulation" option set so I get a running total of the percentage as I go down the chart.
I want to only show the first row where the Total Pct column is >= 70% (see highlighted value).
How can I show only the row of the chart where the Total Pct value is >= 70%? Is this possible???
Thanks for the help.
Ed T.
On the Chart's Dimension Limits tab set the "Show only values that are" .... "Greater Than" as an "Exact Amount"
You'll need to make your column "Total Pct" as the first column.
Hi,
maybe using an expression using only?
Thanks
André Gomes
Hi Andre,
you can try this inside expression...... =IF(Total Pct>= '70%',sum(Total Pct))
Regards
Rakesh