Question Re: Table layout - two values in one cell in Technology Q&A

Table layout - two values in one cell

vaclavhlozek — Thu, 12 May 2022 08:00:40 GMT

Hello,

I would like to kindly ask you whether SAC allows to merge two values into one cell? We have a query that is created to be able to give these two type of values. The issue is that we do not know whether this layout is possible in SAC.

I would like to see the table in the way as you can find in the attachment. Could you please give me any hint or help?

Thank you a lot in advance.

Kind regards,

Vaclav

Re: Table layout - two values in one cell

avsalynin — Thu, 12 May 2022 08:20:43 GMT

vaclavhlozek

you can do smth like this:

2 measures in rows after dimension & apply styles cell rules

Re: Table layout - two values in one cell

pooja_elangovan — Thu, 12 May 2022 08:23:28 GMT

Hello Vaclav Hlozek,

Yes! obviously, in SAC we have an option called merge cells in the story styling but we can't merge cells containing data. We can do join only if cells are empty.

Thanks,

Pooja.

Re: Table layout - two values in one cell

fykusa — Thu, 12 May 2022 13:19:00 GMT

Sorry, but original request was not about putting key-figure into row.

Structure of columns is still KF- based, not as in your example dimension-based. More closely seems to be answer from Ms. Elangovan below, but there totally useless when applyable only for empty cells.

Re: Table layout - two values in one cell

PrathameshA — Thu, 12 May 2022 16:31:39 GMT

Hello,

"We have a query that is created to be able to give these two type of values. "

Which two type of values, can you explain ?

In your layout, there are 7 different columns. Few columns like Budget and Last Year are showing a number in black and another number (variance) in red or green.

If you are saying that black color number and green / red color number are coming from two separate key figures / measures, then I don't think it is possible to achieve exact same layout in SAC.

However the following may be feasible:

Thanks,

Prathamesh

Re: Table layout - two values in one cell

fykusa — Thu, 26 May 2022 07:44:44 GMT

Hello, here is the solution:
(needs to be mentioned here that this works for static report, not for further drilldown)

Query with defined structure in rows and in columns, hide columns not needed in output (these % KFs) and specific cells override in query definition (crete reference cell for these hidden % KFs, map them with formula to wanted position)

Result in SAC after some styling:

What is still not solved is conditional formating applied only to these specific % rows. Filtering of formating to specific values in rows structure seems to be not working 8(

Tip: to hide unwanted values can be achieved by manually setting font color the same as background color in cell styling.

Filip