Pivot table value bifurcate

[prma7799]

Hi All,

I have two table with same column but different data I have achieve require output with individual pivot chart now i want to combine all these data with one pivot table.

For example :

I have table PQR and LMN in that I have location group wise data now i want to create chart like attached . I getting difficulties in that can anyone please help me out.

PFA...

[rohitraut]

hello,

try this

First concatenate both base tables, then take a pivot table.

[prma7799]

Hi Rohit ,

I did the same but I am not getting separate values it is added all values into the one value

[shraddha_g]

Link both table by field Location group and then try to create required chart.

[rohitraut]

Can you please share the sample data?

[prma7799]

Hi Rohit,

I have concatenate both table with Flag am able to achieve the bifurcate but at Total level it adding all values

In the attached I getting all values as total but I want all Invoice total and for final total I want all invoice total - credit total.

[shraddha_g]

Share sample app to help you better

[prma7799 · Accepted solution]

It is done by using straight table...

Thank for your reply...

[qliksus]

Just join the two tables based on LocGroup and Currency

LOAD * INLINE [
    Loc Group, Currency,  Amount (FC) ,   Amount (Rs.)
    ABC, EUR,  200.00 ,  140.00
    ABC, USD,  270.00 ,  183.00
    XYZ, AUD,  418.00 ,  212.00
    XYZ, EUR,  940.00 ,  677.00
    XYZ, GBP,  135.00 ,  110.00
    XYZ, INR,  -   ,  407.00
    XYZ, USD,  233.00 ,  158.00
];

LOAD * INLINE [
  
    Loc Group, Currency,  Amount ,Amount1
    Less , GBP,  273.00 ,  227.00
    Less , USD,  187.00 ,  126.00
];

And take the below values in the chart

Dimension: Loc Group, Currency

Expression: Purgechar(sum([Amount (FC)]) - (sum(Amount)),'-')