Add formula to Pivot Diagram

[Dean]

Any idea how I add a formula to calculate the percentage for each node in a
level, e.g. each Division has revenue of x $ which show up as the total
revenue in the top node. I'd like to add an additional data field to show
that Division 1 is 23% of the total and Division 2 is 77% of the total.

Thanks
Dean

 

[Al Edlund]

you might check this out

http://blogs.msdn.com/visio/archive/2007/03/06/custom-formulas-in-data-graphics.aspx

al

 

[Dean]

Al, thanks, but that article is what made me ask this question. The article
states that we can use any valid
ShapeSheet expression, but does not provide any info how to write a valid
expression. On my pivot diagram, I can see the numbers I want to include in
the formula, I just don't know how to structure the equation.
Dean

 

[John Goldsmith]

Hello Dean,

You might find this link useful on writing formulae:

http://msdn2.microsoft.com/en-us/library/aa200961(office.10).aspx

Also, if you're not familiar with the ShapeSheet, then you might want to
read this blog post:

http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html

Hope that helps.

Best regards

John


John Goldsmith
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[Dean]

John, thanks but there doesn't seem to be anything is the docs you referred
me to that addresses Pivot Diagram shapes. Its still not clear to me how
ShapeSheets are implemented in a Pivot Diagram and how to refer to the shapes
in this type of diagram when creating a formula.

 

[David Parker]

In the Sales Summary sample, for example, you could enter the formula
={Revenue}/Sheet.5!{Revenue} for a new graphic item for pivot nodes on the
second level... and format the values as percentage!
This is because the top node has the shape Id of 5.

 

[Dean]

Thanks, that works great.

In the Sales Summary sample, for example, you could enter the formula
={Revenue}/Sheet.5!{Revenue} for a new graphic item for pivot nodes on the
second level... and format the values as percentage!
This is because the top node has the shape Id of 5.