Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a little problem with a Pivot table. I understand why this happens but not how I can solve this in some easy (or hard) way
The information in the Pivot table come from following tables:
Fact table: [Innvoice No.], [Line Type], [Spl Country],[Receiver Country],[Order Type],[Inv Amount]
GenLedg : [Account], [VAT Code], [GL Amount]
'
I don’t need both [Inv Amount] and [GL Amount].
What can I do to get rid of the doubles?
One Idea was to concatenate Spl Country to one string if there are two [Spl Country] but I’m not sure how I do that.
Would be very thankful if someone could help me or give me some good advice.
// Fjalar
Check if it is correct now and let me know.
Maybe there will be something more to do on expressions side.....
regards
Darek
Hi,
please attach application with sample data.
regards
Darek
Hi,
I don't want to have the doubles. If it is possible in some way to mark invoices that have doubles and/or concatenate supplier in one field.
Fjalar,
i'am trying to find those "doubles", but i'am not sure where they are
You told:"I understand why this happens" .... So, please maybe export your chart to excel and then mark cells with this problem.
regards
Darek
The best way for me to help you will be if you show me 2 things - how your chart looks now and how you want it to look. Having this difference it will be easier to find how to resolve it.
regards
DArek
In sum(SalesValues) I get the totals for each country because those fields are in the same table but doubles for each Account (from another table)
In sum(GL_Amount) I get the totals for each Account because those fields are in the same table but doubles for each country ( from another table)
I think it would be nice if I could check it there are mote than one country in each invoice and in that case concatenate the values.
See attached file. I have no idea if this is possible.
// Fjalar
Check if it is correct now and let me know.
Maybe there will be something more to do on expressions side.....
regards
Darek
THANKS A LOT!! YOU made my day.
Looks like this now in the real application.
Best Regards
// Fjalar