Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple variable, vKPI.Backlog.#Lines, that allows me to count total lines :
=count({<KPI = {'Backlog'}>}Order_ID)
And as a total count this works fine. When I use this in a straight table using customer as dimension and the following as the exp:
$(=vKPI.Backlog.#Lines)
I get the overall total for all customers against each customer. Is it not possible to use a variable like this in a straight table?
Hi Dermot,
change your variable to
count({<KPI = {'Backlog'}>}Order_ID)
by removing the equals sign
And your expression to
$(vKPI.Backlog.#Lines)
Share screenshot of table.
What are the fields you have used? and are those linked?
Hi Dermot,
change your variable to
count({<KPI = {'Backlog'}>}Order_ID)
by removing the equals sign
And your expression to
$(vKPI.Backlog.#Lines)
Marcus, Doh! I knew it would be something simple, many thanks!