Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
hello,
try this
First concatenate both base tables, then take a pivot table.
Hi Rohit ,
I did the same but I am not getting separate values it is added all values into the one value
Link both table by field Location group and then try to create required chart.
Can you please share the sample data?
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.
Share sample app to help you better
It is done by using straight table...
Thank for your reply...
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)),'-')