locked
How to access Variables in Power Pivot for Excel 2013 RRS feed

  • Question

  • Dear All,

        I'm creating reports in Power Pivot reports (Excel 2013). The reports looks like below.

    Enter Number Of Months  :  2 (USer Can enter any value)

    ProductId     Sales        Total Sales 

    1                   100           100*2 (My sales value is multiply with value in Text Box)

    2                   200            200*2 (My sales value is multiply with value in Text Box)

       

    Can some one help on how can I use Variables in PowerPivot and How Can I use variable values in Calculations.

    Regards,

    Praveen 

     


    Regards, Praveen

    Wednesday, March 19, 2014 1:46 AM

Answers

  • Hi,

    Based on my understanding, you want to add create a calculated column to get total Sales, if your get data source from excel worksheet, you can create formulas to calculated total sales in worksheet, you can also create formulas for calculations in Power Pivot.

    Please look at the screenshot and links below:

    #Create Formulas for Calculations in Power Pivot

    http://office.microsoft.com/en-in/excel-help/create-formulas-for-calculations-in-power-pivot-HA102836100.aspx

    Please feel free to let me know, if I have any misunderstanding.

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. 

    • Edited by Marvin_Guo Friday, March 21, 2014 9:42 AM
    • Marked as answer by Marvin_Guo Thursday, March 27, 2014 3:41 PM
    Friday, March 21, 2014 9:42 AM