1 Reply Latest reply on May 14, 2018 10:03 AM by Deepak Rai

# Table calculations in a worksheet

I am looking to return a percentage for the number of times a field appears with a value in across a number of "area's",

For example - I have several common fields (e.g. Handbags, shoes, lipstick) across several department stores, some of which return 0 value for a certain field (as some have sold none), some of which return a positive value for a certain field  (as they have sold numerous handbags),

I'd like to know what % of department stores have sold handbags in any capacity, e.g (5 out of the10 department stores have sold handbags... therefore I would like it to show 50%),

In essence a count of positive hits across a consistent data set.

the data set resembles the following:

store 1          store 2           store 3          store 4            % (what we would like to calculate)

Handbags      £5k                £0                    £20k            £0                 50%

Shoes            £7k                £8k                  £9k              £0                  75%

Lipstick            £0                £0                    £0                £10k              25%

• ###### 1. Re: Table calculations in a worksheet

First you need to Pivot your Stores and then write a Calc to get it

Thanks

Deepak

If it Helps, pl mark it Helpful and Correct to Close Thread,