Want to display values for two queries in the same chart

[fml55555]

Hi gurus,

I am trying to build a Bar chart where one of the bars is populated from one query and the second one from a second query. I have tried to union them and use the union but it fails with error messages (attached).

Query 1

Gets input for month year from a user (this is done by a macro in the slicer) and calculates a measure

Query
Uses the macro and lag function to build the same measure value for previous period


eg. if query 1 builds
revenue for
feb/2014
query 2 builds revenue for
Feb/2013

I am not sure how to proceed from here

[Francis aka khayman]

you don't need a union since you are using dimensional. you just need to build a set..


set([input from user];lag([input from user];1);lag([input from user];2))

[fml55555]

Thanks a ton Khayman! It is working... :)