pivot table count

I have a large batch of data, below is just a short sampling of it, that I am trying to report on. If the same store, on the same date, had the same style I only want it to be counted 1 time when I pull the data into my pivot table. I've tried concatenating those 3 elements; Store Name, Show...

<tbody> sentiment score 1 1 0.9 0.9 0.8 0.8 count 300 250 5 3 2 16 </tbody> I have a pivot table here with columns equal to sentiment scores. I would like to sump up distinct values for each sentiment score to get something like this: <tbody> sentiment score 1 0.9 0.8...

I have created a large spreadsheet which breaks out a monthly forecast and within this forecast there are dollar values relating to each of the items on this forecast. In the same row as these dollar values i have assigned a date to each item. I would like to produce a table as seen below which...

I am trying to produce a pivot table that will count a column that contains week numbers when specific reports were closed. However, as the cells within the column contain a formula it seems as if the pivot table will include those that are 'blank' i.e. the result of the IF statement is ""...