Horizontal Contribution

[ErickRuiz7]

Hi Sisense Devs,

I'm using a Pivot Table Visual in which Im using employee_name as my rows, phone state as columns (With over 15 categories), phone state duration as values, I converted the values to % using the CONTRIBUTION formula on Sisense, but Im getting the contribution per Column, this is something I don't need at this time, what I actually need is the contribution per row, is there anything I can do using only formulas or would I need a custom code table on the cube?

Thank you all.

[DRay · Accepted solution]

Hello @ErickRuiz7,

 Can you take a look at this document and let us know if it has the answer you are looking for?

https://community.sisense.com/t5/knowledge/calculate-pivot-total-at-row-level/ta-p/325

Thank you.

[ErickRuiz7]

It worked perfectly, thank you so much.