Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that when the values for "Activities" sum up to 0, the subtotals do not appear. However, when adding dimensionality() as an expression, then the subtotals appear correctly. Please see the example below...
Activity | Activity Description | Source | GL Entry Name | GL Amount | |
A06E-019 | RESUSCITAIRE WARMER | AD | 997810 DRAEGER MEDICAL | ($482.18) | |
A06E-019 | RESUSCITAIRE WARMER | CP | WORK IN PROCESS | $482.18 | |
A06P-500CONST | AIR HANDLER UPGRADES CONSTRUCT | AD | 70000 OSCAR J BOLDT CONSTRUCTION | $1,446.53 | |
A06P-500CONST | Total | $1,446.53 | |||
A08E-109 | WAITING ROOM FURNITURE | AD | 146000 EMMONS BUSINESS INTERIORS | $46,165.43 | |
A08E-109 | WAITING ROOM FURNITURE | CP | WORK IN PROCESS | ($46,165.43) | |
A08E-707 | ORTHOPEDIC DRILLS | AD | 419500 SYNTHES LTD | $37,903.68 | |
A08E-707 | ORTHOPEDIC DRILLS | CP | WORK IN PROCESS | ($37,903.68) | |
Total | $1,446.53 | ||||
$1,446.53 | |||||
With Dimensionality() expression | |||||
Activity | Activity Description | Source | GL Entry Name | GL Amount | Dimensionality() |
A06E-019 | RESUSCITAIRE WARMER | AD | 997810 DRAEGER MEDICAL | ($482.18) | 10 |
A06E-019 | RESUSCITAIRE WARMER | CP | WORK IN PROCESS | $482.18 | 10 |
A06E-019 | Total | $0.00 | 2 | ||
A06P-500CONST | AIR HANDLER UPGRADES CONSTRUCT | AD | 70000 OSCAR J BOLDT CONSTRUCTION | $1,446.53 | 10 |
A06P-500CONST | Total | $1,446.53 | 2 | ||
A08E-109 | WAITING ROOM FURNITURE | AD | 146000 EMMONS BUSINESS INTERIORS | $46,165.43 | 10 |
A08E-109 | WAITING ROOM FURNITURE | CP | WORK IN PROCESS | ($46,165.43) | 10 |
A08E-109 | Total | $0.00 | 2 | ||
A08E-707 | ORTHOPEDIC DRILLS | AD | 419500 SYNTHES LTD | $37,903.68 | 10 |
A08E-707 | ORTHOPEDIC DRILLS | CP | WORK IN PROCESS | ($37,903.68) | 10 |
A08E-707 | Total | $0.00 | 2 | ||
Total | $1,446.53 | 1 | |||
$1,446.53 | 0 |
GL Amount = sum([GL Line Amount])
Thanks,
Dan
I actually figured out a work-around for this. I included the Dimensionality expression, then set the background and text to White(). May not be ideal, but it works for my application.
Thanks,
Dan
I actually figured out a work-around for this. I included the Dimensionality expression, then set the background and text to White(). May not be ideal, but it works for my application.
Thanks,
Dan