Skip to main content
Solved

Percentage of sales column set

  • August 25, 2023
  • 1 reply
  • 114 views

Forum|alt.badge.img

How do I create a column that calculates % of sales for each row?  

Best answer by Laura02

Hello,

Suppose Total Sales is Row # 0102:

 

In the % Sales Column, Use Calc column type with this formula:

This second Link below is an example showing how to use *any* total line to show each account in the group as % of total using Base Row features. For example, each COGS account as % of  Total COGS:

 

Laura

View original
Did this topic help you find an answer to your question?

1 reply

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • August 25, 2023

Hello,

Suppose Total Sales is Row # 0102:

 

In the % Sales Column, Use Calc column type with this formula:

This second Link below is an example showing how to use *any* total line to show each account in the group as % of total using Base Row features. For example, each COGS account as % of  Total COGS:

 

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings