Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a chart with two expressions. The first expression must have one dimension and the second expression must have a different dimension. In my case, it doesn't work using the conditional option on dimensions tab. Is it achievable using another method?
Any ideas are welcome.
Thank you.
Use for example Sum(Total <field1, field2...> expr.)
Can you post a screenshot of what you are trying to achieve ?
Sounds like you just need to enter the expressions differently.
i.e
expression 1 (current year) would be:
sum({$<Year={$(=Only(Year))}>}qty)
expression 2 (previous year) would be:
sum({$<Year={$(=Only(Year)-1)}>}qty)
But you would need to post what you are looking to acheive