combine

[dnowebdn]

I have to combine all into one chart

[sunny_talwar]

May be this

Table:

LOAD Sales,

    Month,

    Year,

    Category,

    KPI,

    Country,

    brace

FROM

[..\..\Downloads\Tests.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate (Table)

LOAD Sales,

    Month,

    Year,

    'All' as Category,

    KPI,

    Country,

    brace

Resident Table;

or this

Table:

LOAD Sales,

    Month,

    Year,

    Category,

    KPI,

    Country,

    brace

FROM

[..\..\Downloads\Tests.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate (Table)

LOAD DISTINCT Sales,

    Month,

    Year,

    'All' as Category,

    KPI,

    Country,

    brace

Resident Table;

[Anonymous]

If you were to create this additional category then there would be no data for it, why do you want to create a third category instead of just selecting two categories simultaneously?

[agigliotti · Accepted solution]

You can do it with a new table as below:

tab_a:

load

     Category

     Category as New_Category

Resident now;

concatenate

load

     Category,

     'all' as New_Category

Resident now;

In the UI you can use New_Category field as filter/dimension.

I hope it helps.