Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My chart 1 is correct , but need to select year = 2015 , may i know how to make like chart 2 ( wrong result ) don't need to select year = 2015.
in other word , i have create a chart 2 , some how it give the wrong value.
Paul
Set Analysis will let you do it.
Set Analysis: syntaxes, examples
Create a variable which contains the selected year, then your set analysis would be:
SUM({$<[YourYearField] = {'$(=vYearVariable)'>} [YourMeasure])
for Chart1
and
SUM({$<[YourYearField] -= {'$(=vYearVariable)'>} [YourMeasure])
for Chart 2
Set Analysis will let you do it.
Set Analysis: syntaxes, examples
Create a variable which contains the selected year, then your set analysis would be:
SUM({$<[YourYearField] = {'$(=vYearVariable)'>} [YourMeasure])
for Chart1
and
SUM({$<[YourYearField] -= {'$(=vYearVariable)'>} [YourMeasure])
for Chart 2
Hi Andrew
Thank you for the SET Doc , yesterday i read after few page for about 20 mins , i can feel my head very pain , will continous reading when i free.
Paul
Stick with it - Set Analysis is very useful. I have required it everyday!