You don't have a numeric field to calculate percentages on
Do you want for example if we only look at Area 1
the number of days of Store ID 54 = 2 as a percentage of the total days of Area 1 = 9 so the percentage is 2/9 = 22.2%
For instance in area 1 I have 4 stores and I need to know the percentages on how often the stores generates in SU MO TU WE TH FR SA. So I can know what days % the distribution center will be processing more purchase orders:
In the picture example I see in are 1 the distribution center will have more purche orders in TU (3 apearences), then in SU and TH (2 apearences each) then FR and MO ( 1 appearance each). I just need some graphics that can represent that on %. In this example would be:
How can I get this kind of analisis, using a dinamic graphic and just filtering the areas and CEDIS criteria, and also that the ranges can be automatically adjustes to the new information?
The lookup will look through the entire text Say SUTU for SU and if it finds SU it will return the text SU . I warped the formula with Istext to convert the text to numeric 1 or 0 to get the count.
Note:2^15 is the maximum number of character +1 a cell can hold.