derived Dimension object

[#1]

Hi All,

I want to show Calculated Dimension values as Sales A,

Sales B ,

Sales C ,

Sales D as show shown in legend.

How to show?

Thanks in advance.

[sunny_talwar · Accepted solution]

Is this what you are looking to get?

I unchecked the 'Show Legend' on the presentation tab to get the names on the axis

[jagan]

HI,

Why can't you do crosstable() and use it as dimension.

CrossTable(SalesType, Sales)

LOAD Sales_Type,

     Sales_A,

     Sales_B,

     Sales_C,

     Sales_D

FROM

DATA.xls

(biff, embedded labels, table is Sheet1$);

Now use

Dimension: SalesType

Expression: Count({<Sales={'>0'}>}Sales_Type)

This way you don't need to write multiple expressions, in future if you get Sales_E for example, this will deal automatically, no need to change your app again.

Regards,

Jagan.