How to map?

[sanjujeeboy]

how to get pie chart with 2 measures

[jyothish8807]

Try this:

A:

Load

MAG,

Revenue,

Unit

from <>;

B:

Load

[MAG Main] as MAG

'MAG Main' as NewField

from <>;

Now In UI make a list box add "NewField" in it.

Create a straight chart :

Dim: MAG

Exp1: Sum(Revenue)

Exp2: Sum(Unit)

Now if you dont select anything, you will get all the values, but when you select "MAG Main" from drop down of "Newfield" you will get only "hybrid,grooming accessories"

[gf]

Map always requires a key value pair. I don't think it is possible to map more than one value.

For example:

If you have a mapping table like:

Key    Value

1          A

2          B

3         C

and another table like 

ShowLetter:

RowNum     Number

1                      1

2                      2

3                      2

Table ShowLetter would look like:

RowNum     Number

1                      A

2                     B

3                     B

How to declare a table as mapping table:

Just write

MapNumber:

Mapping LOAD Key as KEY, Value as VALUE FROM.....

And in the table where you want to map

LOAD ApplyMap('MapNumber',vKey) FROM....