show the same measure values for two different dimensions

[jananireddy]

Hi All,

In the attached image there are two bar charts and the table below shows the data loaded in my app. I have replicated a simple scenario in my attached app to get a solution.

Both my bar charts have the same measures, but the dimension which is a time period differs.

I need a solution which can show the same measure values for both dimension (i.e. month_actual and month_trans). Is this possible by writing set analysis in the dimension expression? or is there any other way i can achieve it

[Silambarasan1306]

Hi,

Here is the solution. Please find the attached application. Writing Set Analysis is the best way to achieve it.

[jananireddy]

Thanks for the quick reply.

In your app you have changed both the measures. I need this to be in both my measures

sum({<month_actual={'FEB'}>}amt_collected)

/

sum({<month_trans={'FEB'}>}amt)

Although my second bar has "month_trans" as its dimension, i want it to contain "month_actual" values too

Regards,

Janani

[Silambarasan1306]

Please find the application.