Pivot Table and Horizontal Calculations

Sonia_4268

Hello, Wondering if we can get some advice on how to program horizontal calculations in a pivot table. Please see below the current view of the Pivot Table and how we need to put in horizontal calcs.

MarkSnodgrass

Unfortunately, what you want to do is not currently possible in the pivot table. I would suggest adding it to the ideas exchange.

You could think about using drill paths to accomplish what you want. Your top level card might have the % change and then you can click into that to see the details.

MarkSnodgrass

You should consider using the flex table chart type to produce the change and % change information. Here's the KB article on it.
https://domo-support.domo.com/s/article/360043429073?language=en_US

While the default setup of the flex table is to show a graph with % change, you can have it show values, so that it looks more like a table.

Sonia_4268

Thanks Mark, We tried the Flex table and we are just trying to add calculated rows and not a bar or line chart. Any other options besides the flex chart?

MarkSnodgrass

Unfortunately, what you want to do is not currently possible in the pivot table. I would suggest adding it to the ideas exchange.

You could think about using drill paths to accomplish what you want. Your top level card might have the % change and then you can click into that to see the details.