Chart values population

[Anonymous]

I have a Excel with 22 Columns, in that I need 14 columns to build my chart and one of the 14 columns is my dimension. All the remaining will be used for generating my bar graph.

I tried using Only() for all the columns which I am trying to populate and it's not working.

Any suggestions?

TIA

[swuehl]

Only() in your expression will only work if the argument to Only() returns a single value in the aggregation scope (basically the scope of the dimension(s)) using the record set that is filtered by your selections.

If there are more than 1 possible value to be returned, Only() will return NULL.

Then you need to consider another aggregation function.

Try Sum(), Count(), Concat() etc.

Use Aggregation Functions!

The Aggregation Scope

[MarcoWedel]

13 Excel columns delivering values for a bar chart (one column for one bar each?) sounds like a use case for

The Crosstable Load

hope this helps

regards

Marco

[Anonymous]

I want everything as a stacked bar chart. As a combination of bar graph and line graph.

TIA

[Anonymous]

Stacked together.