Forum Discussion
DianaProcesos
Aug 28, 2021Copper Contributor
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...
SergeiBaklan
Aug 28, 2021Diamond Contributor
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.