Switch Expression dimension

[Anonymous]

Hi,

I have a question,

I have a bar chart like this:

Is it possible for me to switch the position between BRAND and MY EXPRESSION (DLV & REQ) ?

I also attach my data and sample file.

Really appreciate your help

thanks in advance.

[MK_QSL]

What is meant by

switch the position between BRAND and MY EXPRESSION (DLV & REQ) ?

Please elaborate !

[sunny_talwar · Accepted solution]

This?

Script:

CrossTable (Name, Value, 2)

LOAD YEARMONTH,

     BRAND,

     REQ_QTY,

     DLV_QTY

FROM

sample.xlsx

(ooxml, embedded labels, table is Sheet2);

Three Dimensions

YEARMONTH

Name

BRAND

Expression

Sum(Value)

[ali_hijazi]

possible if you have a record for Requested quantity and a record for Delivered quantity then next to each record you would put Flag as R or V

in this way you would use the Flag as a dimension

and you need to add the Brand as a dimension too

in your expression you would count the brands (how many times a brand was ordered or delivered)

is this what you aim for?

[Anonymous]

Yes that's my goal.

Thanks once again ! Really appreciate your help