Use field names as Dimension values

[julioarriaga]

Hi everyone,

Thanks in advance for your help. I have two fields "Total Sales" and "Gross Sales" (just an example, I have way more) that I wish to show in the way of Image 1, and information is as Image 2.

Kind regards.

(Image 1)

(Image 2)

[rwunderlich · Accepted solution]

My first response is that it's as simple as creating a Straight Table with expressions like "Sum([Total Sales])" and then checking "Horizontal" on the Presentation tab.  I suspect you may be trying to do something more sophisticated?

-Rob

[arvind_patil]

Hi Julio,

First create Inline table

DimInline:

LOAD * INline [

Dim

[Total sales]

[Gross Sales]

];

Use  expression in Straight table:

Sum({<Dim={"Total sales"}>}Total Sales)

Sum({<Dim={"Gross Sales"}>}Total Sales)

Thanks,

Arvind Patil

[julioarriaga]

Indeed, my final idea is far more complex, but I think I will keep it simple in order to not convolute innecesarily the question. When I advance more my app, I will post other questions.

Thank you for your response!