Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data Model Retail Business (help!!)

Hi Guys,   I work on the retail business (several stores and several products) and i would like to make a report about: 1) Products with NO SALES 2) Products with stock coverage: Products with >...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Thanks for the input!

I will test it and then came to give feedback.

Cheers and thank you again

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi richbenmintz 

 

The solution is working perfectly!

 

I was trying on the final model to show only in percentages. I donne it but know i found an error.

 

For example, in the month 11, Paris Store. Yellow highlighted.

I was trying to just show the "More than 50 days" and the "No sales" on the table below and, at the same time, the percentages of these two "labels", according with TOTAL stock of the store (and not just the ones i selected "more than 50 days" and the "no sales").

However, when i select the "no sales" and the "more than 50 days" i have a % of 100% for the total of the store. However the righ percentage should be 128 / 179 = 71,5% and not 128 /128 = 100%. I hope i make myself clear on these explanation. Is there any chance to bypass this?

Cheers!

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    Hi Anonymous,

     

    Can you provide the measure you created? will be easier for me to understand what needs to be changed.

     

    Thanks,