Bar chart with mixed dimension

[Napster]

Hi All,

I have a table which contain YEAR, MONTH & SALES data. I have created a bar chart where i haves used YEAR as dimension and Sum of SALES as measure expression.

My requirement is that when user has selected any year value, have to show sum of each month value for that selected year  and rest of unselected year value will show as it is.

Attaching my output result, may it will help to understand my requirement.

Any help really appreciate.

Thanks

[dplr-rn]

You can use drill down group to show month values when year is selected. but the second part of your requirement (rest of unselected year show as is) is not possible IMHO

[sergio0592]

Hi,

You can achieve this with:

-Create a Dim "Data island table"

Dim:
LOAD * INLINE [
Dim
1
2];

-In your bar chart

as dimension

pick(Dim,Month,'Rest')

as expression

pick(Dim,sum(Sales),Sum({1-$} Sales))

Take a look to the attached qvw file. Is it what you're trying to achieve?

[Napster]

This is what i am not look for.
Have attached my required output screenshot in my main thread. May this will help you to understand the requirement.

Thanks