unable to get all values on chart

[#1]

i have a table such as:

category	value	productID
category1	10	1
category1	20	2

when i create a chart and give dimension category it is showing nothing for category 1. but when i choose the product it is showing. what to do if i need both in chart?

[MK9885]

Maybe use productID as Dimension?

Cus productID has unique values unlike category field (which are same).

[#3]

thanks for the reply.

this was just an example. if i have more categories and i need all of them then what to do?

[veidlburkhard]

Hi ashwin,

what do you mean 'it is showing nothing'?

When I load your data I see it all:

Can you explain a little further what your problem is?

Regards

Burkhard

[#5]

what dimension did you give?

[#6]

i have to select category as dimension.

[MK9885]

As the dimension Category has same value I.E Category there will be only 1 bar but the Y-Axis scale will change if you select Product Id 1 or 2/ Value 10 or 20.

[MK9885]

If you have 100 records with name category1 under field Category then you'll get only one bar for dimension and rest of the bars for measures.

Your Y-Axis values will change upon selection of ProductId or Value but if same value in dimension will get you only 1 bar.

And if you use Product Id as dimension (which has all different values) then you'll get more bars..

You can test by your self by taking an example of what you want to achieve. Make 1 chart with productid as dim and another chart as category as dim.

You'll know the difference.

[swuehl]

I assume you just need to

Use Aggregation Functions!