Cross Table % calculate problem

[Hesloan Viana]

Hello, i need to show, on a cross table, the % of categories for every month but i need to use the horizontal axes (where my date column is) for 100% every month.

[Richard Pobi]

From your value selector > Under Aggregation, select % of Total

After that go to Properties > Formatting > Percentage

[Hesloan Viana]

Sorry, i didn't understand. Where should i change the aggregation

 

My expression on cell value actually is: 

 

Sum(UniqueCount([PROTOCOL]) / Sum(UniqueCount([PROTOCOL]))) OVER (Intersect([Axis.Rows],[DATE_EXECUTION])).

 

 

[Richard Pobi]

Go to where you select example SUM, Avg, etc for your value you will find % of Total over there. Select the % of Total.

 

After that go to Properties > Formatting > Percentage 

 

or try the below expression

 

Sum([Value Column]) THEN [Value] / Sum([Value]) OVER (All([Axis.Rows]))