Calculate percentage based on distinct values from same column (pivot table)

[pabloperezgarcia]

Hello,

I need to know how to calculate percentage based on distinct values from same column (pivot table) only adding one column. 

Something like this:  

Regards,
Pablo Perez 

[chrismarlow · Accepted solution]

Hi,

Do you know the table is only going to have 2 dates and model as row?

If so how do you identify the dates? Because this would likely be easier to do as a straight table.

If it could have more than 2 dates, how would you display that?

Cheers,

Chris.

[pabloperezgarcia]

I'll managed only two dates values to compare. The pivot table is something like this and I need one more column to calculate de percentage.

cheers,
Pablo

[chrismarlow]

Hi,

Other folks may know better tricks but I think this is a bit fiddly with the out of the box visualisations.

You could look at some of the ideas on the attached that might get to what you need.

Cheers,

Chris. 

[pabloperezgarcia]

Chris, 

It worked well, thank you!! 

Cheers,

Pablo Perez