How to get data like this in QV Report?

[dmohanty]

Hi All,

I have a source table like this (attached file: refer 1st tab). Table has 3 main Fields: REGION, PRODUCT, SALES.

Now I have to show data in QV like this below image (in Straight Table/ Pivot/ Table Box). (Also please refer 2nd tab in attached excel file).

I should have a list box called REGION, Whatever value I select from List Box, the 1st Dimension in Chart should always be fixed i.e IND. Only the selection should affect the 2nd Dimension and like wise it would show the data.

Could someone please help in achieving this? It will be really appreciated

Regards!

[Anonymous]

It can be done using a straight table with Product dimension and all other columns as expressions.  But, to tell you the truth, I would not recommend this layout.  Notice that if you remove both "Region" columns, you don't loose any useful information.

[dmohanty]

Thanks Michael,

But I need this chart for Sales comparison for each Product in Region wise and compare each Region sales with that of IND.

How the value of IND can be fixed in a Chart, irrespective of selections in Region list box?

Could you please show an example by taking this sample data?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[dmohanty]

Thanks Gysbert for your prompt help.

Is it not possible to show 2 dimensions : Region IND, Region Others in the chart?

As I wanted to select Region from a List Box.

Region IND should always have IND, irrespective of Selections.

Region Others should have rest 3 values.

[Gysbert_Wassenaar]

Sure, just add two expressions:

Region IND: 'IND'

Region Other: only(Region)

Drag the two expression columns to the left of the Product dimension.

Just make sure you only select one Region in the listbox.

As Michael says the two Region columns are totally meaningless. You can see in the listbox which Region you selected for the Other Region. And the Sales IND will always be the sales for the region IND. Showing a column with IND in each records is not adding any information to that.

[dmohanty]

Thank you very much Gysbert and Michael.

It was pretty simple though, I could not figure it out.

Now I can achieve my desired results. Thanks again!