Different currencies in Pivot table

Question & Answer
,
1

Hi,

Is there any way of including different currencies in the same visual. I have some records where the sales is in £ and some in euros. I could only set one currency in pivot table. This needs to be in number since I am using it in pivot table.

2

Hi @liya101
do you have a field to differentiate between the currencies? So how do you know it is a EUR or GBP?
BR

1 Like
3

I got 2 clients - A and B . The sales of A is in pounds and sales of B is in Euros.

4

And you dont want to bring the currency in a seperate column? Because i guess thats the only option, if you want to keep the aggregations.

5

Hi @ErikG

Thanks for your reply.

I can create a calculated field if the customer is A, then it should be euros and If its B , it should be £.

But If I wanna show the currency in a different column in a pivot table, there wouldn’t be any option to show it without any aggregation.

image
image341×368 13.2 KB

image
image224×211 7.43 KB

6

You would need the field in row or columns, not in the values, as you want to show a string

7

Just wondering if there’s a better way to do this ?

image
image400×457 9.36 KB

1 Like
8

Hi @liya101,
Currently with QS limitations, I believe that the way you have it setup is the best option.

Let us know if you have any additional quesitons, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

1 Like
9

When you are putting the currency in rows, does that not give a better alignment?

10

Hi @liya101,
Since we haven’t heard back in a while, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!