Forum Discussion

DianaProcesos's avatar
DianaProcesos
Copper Contributor
Aug 28, 2021

Pivot Table Gran Total

Hi Everyone¡.   Thanks a lot for any support that you can give me....   Do you know if it is possible to add some formulas or change the condition to sum to get the gran total in a pivot table?, as...
BI & Data Analysis
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 28, 2021

DianaProcesos 

You may

1) use Power Query to query the range, replace values with condition on null and return query back as PivotTable

2) creating PivotTable add data to data model, add DAX measure to it like

Dispatch/Exports TLU2/Withdrawn Volumenes Adj:=IF (
    AND ( ISFILTERED ( Range[System] ), VALUES ( Range[System] ) = "Tuberia 2" ),
    BLANK (),
    CALCULATE (
        SUM ( Range[Dispatch/Exports TLU2/Withdrawn Volumenes] ),
        Range[System] <> "Tuberia 2"
    )
)

and use it in PivotTable instead of implicit column aggregation.

 

Bot PivotTables are in attached file, in both filtering value is hardcoded.

Resources