Can you create a Summary Number that shows a subtotal percentage?

Joe_M · June 2020

Good afternoon,

Is there a way to create a Summary Number that shows what percentage a subtotal represents? For example, if I have a table that is showing 10 rows out of 1,500 rows, and those 10 rows equal 20% of my sales for the month, how can I create a Summary Number that shows 20%?

THanks!

jaeW_at_Onyx · June 2020

@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for.

You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can build it all out.

This tutorial can work as a foundation! Good luck!

https://www.youtube.com/watch?v=ZPf41Fjn1H8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=20

jaeW_at_Onyx · June 2020

@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for.

You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can build it all out.

This tutorial can work as a foundation! Good luck!

https://www.youtube.com/watch?v=ZPf41Fjn1H8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=20

Joe_M · June 2020

Thanks Jae; I did reach out to see what would be possible. Thanks for the quick reply.

Can you create a Summary Number that shows a subtotal percentage?

Best Answer

Answers

Categories