Home Forums Power Pivot Variance Between Two Cost Centers

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  bcobrien77 2 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #11990

    bcobrien77
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    Hi,

    I am trying to create a variance so that I can compare two cost centers on their actual financial performance.

    I have basically 100 cost centers with a few years of financial data and what I am trying to compare is

    Property A                   Property B                  Variance

    Total Expenses      Total Expenses        Property A Total Expenses – Property B Variances.

    Ideally the user would be able to select the properties from two different slicers or one if it is easier.

    I am definitely stuck on how to achieve this so thanks in advance.

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.