J
jademaddy
I am trying to compile a pivot chart that is based on a query that will show
the worst 10 performers based on their stockloss results from a list of
stores. Each store has its own name and branch number which are unique and
each store may have had more than one stocktake in a year. When I run the
query it returns the correct number of stores and their specific audit
results.
However when I run the pivot chart based on this query because on occasions
the same store may have had more than one audit and both of these will be in
the top ten the pivot chart is only showing one entry for the store. This I
believe is because of the duplication. Can anyone assist in how to make the
pivot chart show all records even if the same town appears more than once in
the query ?
Many Thanks
the worst 10 performers based on their stockloss results from a list of
stores. Each store has its own name and branch number which are unique and
each store may have had more than one stocktake in a year. When I run the
query it returns the correct number of stores and their specific audit
results.
However when I run the pivot chart based on this query because on occasions
the same store may have had more than one audit and both of these will be in
the top ten the pivot chart is only showing one entry for the store. This I
believe is because of the duplication. Can anyone assist in how to make the
pivot chart show all records even if the same town appears more than once in
the query ?
Many Thanks