calculated dimensions

[yogitamehta10]

i have a year dimension , I want this to work like this , year  where cycle is current cycle and Last year at calculated dimensions  , I want those years to show?

I have tried to give if conditions but no luck?

[yogitamehta10]

any response??

[shanky1907]

Can you please explain more?

[yogitamehta10]

my dimension is year  that has 2016 and 2017   i have two set of data for 2017 ,
where  1st set of data is c1 and another set of data is c2 , so i have a field in my data  is c that says c1 and c2 and for 2016 it says LY.

so i want to show bar graph where dimension is Year  and  i want to how 2016 data and 2017 data in that , that means 2017 I should point to c1 and 2016 should point to LY.

[VishalWaghole]

Can you please upload some sample data with expected output.

[Anonymous]

so for 2017, u have 2 sets:- c1, c2 where c1 is current dataset.

for 2016, u have only 1 set and that is LY...is this correct?

[yogitamehta10]

‌exactly

[ajaysingh29]

If you have dataset, like shown in image below :

Please check attached qvw.