Forum Discussion
SupermercadosV
8 years agoFrequent Visitor
% 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 %...
SupermercadosV
8 years agoFrequent Visitor
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 % 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.
Cordially B. Estevez