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

Joe_M

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

@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

@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

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