Forum Discussion

Carlos_Gomez's avatar
Carlos_Gomez
Copper Contributor
Sep 28, 2019
Solved

percentage of sales advance in pivot table

Hi, people!    Yesterday I was trying to make a pivot table that shows "presales", "sales" and de % advance [wich means "sales/presales"].   To be clear, in my work we sell packages to the retail...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 28, 2019

    Carlos_Gomez 

    If your data is like this

    to create PivotTable as on the right

    - add data to data model creating PivotTable

    - add three measures to the data model, using PowerPivot or from right click menu on Table

    Measures are

    Sale:=CALCULATE(SUM(Table1[Amount]),Table1[Kind]="sale")
Presale:=CALCULATE(SUM(Table1[Amount]),Table1[Kind]="presale")
Sales %:=DIVIDE([Sale],[Presale])

    - add them to values of the PivotTable

    - apply formatting and design as desired

Resources