Limiting dimensions and measures in objects

[Amit_B]

Hi,

I have budget data and actual data. I need to show the actual data by years and months (depending on the time selected), and also the budget data for the current year by month (even if the current year is not selected).

From what I see, the objects do not allow such a view and limit the amount of dimensions & measures. Does anyone have a solution for this issue?

I'm attaching a picture of a certain solution that I thought of but I can't implement it. I tried to use Bar Chart and Combo Chart, and tried changing the script with some variables.

Thanks!

 

[anat]

For budget measure always use Max year and bypass month and year fields in set analysis

[Amit_B]

Hi,

I know how to define the current year and month in Set Analysis in the measure of the budget.

The problem is that I cannot use 2 dimensions (first for MonthID as 'Group', second for Year as 'Bars') and 2 measures (first for actual, second for budget) in the object.