calculate sales weight for different stores, but it doesn't work after breaking down | Community
Skip to main content
V
VickyYa
January 26, 2024
Solved

calculate sales weight for different stores, but it doesn't work after breaking down

  • January 26, 2024
  • 1 reply
  • 506 views

Hi all,

 

I setup a new metric as weight by sales for different stores located in different provinces. (revenue/sum of revenue of the column). And I also want to breakdown each store by product, and I want to this could give me the sales weight for different products. The problem is when I breakdown the store, and adobe gives me the sales weight of products based on the total revenue of this store, not the total revenue of the company. Anyone can help? thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

This is a tricky one... breakdowns are essentially like quick segments... so your metrics are also based on the store because its essentially segmented... 

 

You might be better off, for this particular report, to take the data out into Report Builder, where you have more granular control over your numerators and divisors... 

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
January 26, 2024

This is a tricky one... breakdowns are essentially like quick segments... so your metrics are also based on the store because its essentially segmented... 

 

You might be better off, for this particular report, to take the data out into Report Builder, where you have more granular control over your numerators and divisors... 

Terms & ConditionsAccessibility statement

Loading footer...