1

Displaying two grids as 1

Hi

I have two tables that I am placing side by side in a presentation, Table A with values for 6 measures for a Company (C) and Table B with 6 percentage measures for C and 2 aggregate groups, M and G. I was wondering if there was a way to 

a) put them into one table, we only want to show the values for the company and not the aggregate groups

or

b) link them in the dashboard so they look neat and are not affected by scaling etc

 

please see attached - where we have placed table A on top of table B

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Satveer,

    The only way for them to be  in the same table (grid) is for the selected items to be in one query. To get the second column, the % for C, you will need to create that calculation in the Companies dimension so that you get the query "Shape" you require.

    Is the data coming from more than one model? If so, the data will need to be combined into one model so that it can be access  in  a single query.

    Otherwise, you will need to play around with the formatting and scaling options in Present to try and get them aligned as closely as possible.

    Hope that helps.

    Ian

Content aside

  • Status Answered
  • 1 Likes
  • 2 yrs agoLast active
  • 1Replies
  • 48Views
  • 2 Following