Hello, I'm wanting to insert an existing formula into a pivot to help me with changing data... but how?
I'm classifying customers and it is based on the "Count" of products they have bought over the passed years.
How do I apply the cell references to the calculated pivot table fields? eg...
Hi All,
I'm a newbie to all this, so forgive the inexperience!
I'm wanting to identify the week number of a date, but I want to start the week number count from 6th April to 5th April the following year. The week number would commence on a Monday (day = 2)...
Help! Any clues?