Forum Discussion

SupermercadosV's avatar
SupermercadosV
Frequent Visitor
8 years ago

% Of total help

Hi,   i need to help to solve a question. In this case i have  a matrix the first row show the store the next one day of week and then i have a column through the years. The measure are Sales and %...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SupermercadosV,

 

Would you please post some dummay data stored in source table rather than just data in visual? Also, please show us your desired result with examples, as I cannot understand " if the first store sells 10000 i need divide the sale of monday / 10000, and if the second store sells 11000 i need divide the sale of monday / 11000 for this store".

 

Regards,

Yuliana Gu

SupermercadosV's avatar
SupermercadosV
Frequent Visitor
8 years ago

Hi again,

 

the dummay data stored are here:

 

I need to find the correct solve to calculate Peso Venta, at this moment i have this that is wrongAnd i need take the next one

 

 

 

I wish I'd explained myself correctly

 

Thanks so much for the response