% Of total help

Question

Hi,&nbsp;i need to help to solve a question. In this case i have&nbsp; a matrix the first row show the store the next one day of week and then i have&nbsp;a&nbsp;column through the years. The measure are Sales and % of Sales, the problem is that when i applied the filter with all(store) and all(dayofweek) give me the total of each day of week overall and i need the total of all day of week only the each store. For example 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.&nbsp;Cordially B. Estevez&nbsp;

supermercadosv · Answer

Hi,&nbsp;i need to help to solve a question. In this case i have&nbsp; a matrix the first row show the store the next one day of week and then i have a&nbsp;column through the years. The measure are Sales and % of Sales, the problem is that when i applied the filter with all(store) and all(dayofweek) give me the total of each day of week overall and i need the total of all day of week only the each store. For example 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.&nbsp;Cordially B. Estevez

v-yulgu-msft · Answer

Hi&nbsp;SupermercadosV,
&nbsp;
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 "&nbsp;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".
&nbsp;
Regards,
Yuliana Gu

supermercadosv · Answer

Hi again,&nbsp;the dummay data stored are here:&nbsp;I need to find the&nbsp;correct solve to calculate Peso Venta, at this moment i have this that is wrongAnd i need take the next one&nbsp;&nbsp;&nbsp;I wish I'd explained myself correctly&nbsp;Thanks so much for the response&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

supermercadosv · Answer

Hi again,&nbsp;the dummay data stored are here:&nbsp;I need to find the&nbsp;correct solve to calculate Peso Venta, at this moment i have this that is wrongAnd i need take the next one&nbsp;&nbsp;&nbsp;I wish I'd explained myself correctly&nbsp;Thanks so much for the response&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;