Hi,
I want to create a calculated field in Pivot table options with a count.
I need to divide sales per quantity of clients.
I tried this formula: ='salesunit'/'client' but the result was #DIV/0!
Also tried this formula: ='salesunit'/count('client') but the result was sales unit / 1.
In attachments, there is an example.
Someone could help me?
Tks
With an helpcolumn to count the clients.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Oldere,Originally Posted by oeldere
Thanks!
It works perfectly with a auxiliary column. There is no way to do this function in calculated field formula?
I will update my excel to 2013 version, and in this version is possible set the calculated field to distinct count. So, will be very important to me put this function inside a default calculated field.
Do you know a formula to do the same thing with distinct count?
Thanks
Maybe it can be done within the pivot table (in excel 2007, which I use), but I don't know that.
Maybe it can be done with pivot table in excel 2010, since I read there are more options available in that version.
I changed the formula... now the count is distinct:
See the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks