Skip to Content
0
Aug 31, 2023 at 08:41 PM

SAC - Table Download to Excel

173 Views Last edit Sep 05, 2023 at 03:45 PM 3 rev

Hi,

I have a table in SAC story which the users are downloading to excel whenever required.

sac-table.jpg

The excel download looks like below, same as the SAC table structure

excel-output.jpg

What the user needs is, they need the dimension headers and measure names in the same line after the excel download, instead of 2 lines, like below.

required-output.jpg

Any setting changes that we can make at the SAC table level or during report download that will help to fulfill this? It is an optimised story, created like an analytical app with scripts.

Thank you,

Sarath

Attachments

sac-table.jpg (36.6 kB)
excel-output.jpg (33.5 kB)