How do I add calculated dimensions values together in a pivot table; the values that appear on the screen in the pivot table object?
I do not want to include any field values from the tables in the final dimension column; I wish to only base the calculation on what values are appearing on the screen in the pivot table.
I suggest you post a sample document to illustrate what you are trying to achieve, with specific detail about what you expect to get from the calculation. Everything else is guesswork.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
