Grouping

[narayanamsn]

Hi,

I have a situation where in I need to group the values of one column and project the metric for the total as well in chart(not in table)

State	Spend	Population
UP	10	8
MP	5	3
Bihar	8	7
Kar	4	4

stalwar1‌

[sunny_talwar]

Would you be able to share your Excel file as a file instead of image?

[sunny_talwar · Accepted solution]

This is what you are looking to get?

[narayanamsn]

Yes Sunny, Did you create any other inline table to refer the Region?

[its_anandrjs]

You can try to use Pick function here for your output.

Regards

Anand

[sunny_talwar]

I did... here is the script I used

Table:

LOAD If(Match(State, 'UP', 'MP', 'Bihar'), 'North', 'South') as Region,

*;

LOAD * INLINE [

    State, Month, Spend, Population

    UP, 1, 10, 8

    MP, 1, 5, 3

    Bihar, 1, 8, 7

    Kar, 1, 4, 4

    UP, 2, 12, 8

    MP, 2, 6, 3

    Bihar, 2, 6, 7

    Kar, 2, 5, 4

];

LOAD * INLINE [

    Dim

    1

    2

];