Possible to show the number of dimension values in a table directly below column?

[Martin_Barth]

Dear Community,

a former BI tool obviously had the possibility to show the number of dimensions directly under the column with the dimensions in the table. So it looked about like this example screenshot:

Here you can see the number of date dimensions directly below. And see the number of the cases with a quick view. (The "normal" measures and KPIs are shown in the columns on the right side of the dimensions, that is the same like in the SAC)

=> Is there any possibility to achieve the same with the SAC? It's no problem counting the date dimensions with an aggregation e.g., but is there any possibility to place the numbers directly below the date columns?

Thanks a lot and best regards,
Martin

[N1kh1l · Accepted solution]

martinbarth

martinbarthOne possible ways could be using aggregated measures using count and then assigning them to text box and place them at the top of table aligning it with columns. Not an ideal solution but it might give the information atleast.

Br.

Nikhil

[Martin_Barth · Accepted solution]

Thanks a lot, Nikhil!

That is about the idea that I also had if there is no other possibility. Creating some kind of text-KPI-tile and placing at top of the table.

And it seems, that this will be our solution...

[N1kh1l · Accepted solution]

martinbarth

Yeah mixing measures with dimension seems impossible in SAC

Br

Nikhil