Pivot table, 2 expressions only in total

[jurielmendiola]

Hello good, I wish I could have the table of the image but so that only the percentage in the total. I want sales by Zone but not your percentage. The percentage is with respect to the year field.

If I disable the% expression then I do not have total%, if I narrow the column then the total% is not seen either.

Zones can be variable, it is a PivotTable, not a simple table.

I also don´t want to lower the area to the rows because in my real case the dimension month can have more than 30 values and the dimension area also, so if under the area to the rows I get a listing too long.

I'm going crazy and it does not seem to be complicated, but there's no way.

THANK YOU!!                   

[marcus_sommer]

There are at least two ways to get a solution. One would be to add '%' as a dimension-value of the field Zona (maybe within a copy of this field only for this kind of table) and then to query this within your expression like:

if(Zona = '%', ExpressionPercent, ExpressionAmounts)

Another way could be to add a further horizontal dimension to your pivot. for example if there is any upper-grouping of Zona or with a calculated one like: = 'All Zonas' and then like above to query it within the expression like:

if(secondarydimensionality() = 0, ExpressionPercent, ExpressionAmounts)

- Marcus

[jurielmendiola]

Thank you very much. Perfect!!!!!