Hi guys,
Please see pic attached.
I need to sit in the chart ie Barclays next to BBVA and then Barclays and Unit Credit and so on for Deutsche Bank and Societe Generale. So it will be kind of
Barclays (CY/PY)-BBVA(CY/PY) and so on for the others.
Please let me know of any idea or if you need further explanations.
Thanks
F Pastor
@FPastor ,
Not sure I understand the question. Is this issue just getting the columns displayed in the proper order? If so, you can add a “Sort Order” column in your dimension table either via Column by Examples in PQ, or SWITCH to create a calculated column.
I hope that’s helpful.
@FPastor I think you need to explain a bit more how this is peer group reporting. So Barclays is seen as a peer to BBVA.
Do you want to see Barclays CY sit right next to BBVA CY but next to each other as Barclays CY/PY does in the picture you posted?
Barclays ie is my client and I am comparing my client to the other peers (BBVA, Unit Credit, Deut Bank and Societe Gene…). See attached by creating a group in the peers table and I can put together Barclay and BBVA and then add the measures CY/PY to the chart. I need to do the same for all other groups ( groups and calculations are done) the issue is displaying it all in a single chart.
See below something like this but a single chart - this is 2 chart together.
Sorry best I can do.
F Pastor
@FPastor ,
I definitely feel like this should be doable. Can you please post some nonconfidential sample data representative of your dataset that we can play with to test some different approaches?
Thanks.
– Brian
Hi @Fpastor, we’ve noticed that no response has been received from you since August 27.
We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Thank you for the help, i decided to go for another type of chart. It can be marked as solved.
F Pastor
