Subtotal columns in workspace freeform tables

Avatar

Avatar
Contributor
Level 2
marting29150335
Level 2

Likes

9 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Validate 1
Boost 5
Boost 3
View profile

Avatar
Contributor
Level 2
marting29150335
Level 2

Likes

9 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Validate 1
Boost 5
Boost 3
View profile
marting29150335
Level 2

28-06-2018

Often we use the report filters in order to filter out specific groups of items in a freeform table, however applying this filter does not have any impact on the figure shown in the column total. The column total accounts for all item totals including those not included in any eventual filters. We have use cases with many of our users where it would be more useful for them for this total to be a subtotal (i.e. total of only items that are included in the filter).

Could this be an option to include in the column total options? I.e. display as subtotal rather than total.

2 Comments

Avatar

Avatar
Level 1
keithyap
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
keithyap
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
View profile
keithyap
Level 1

02-07-2018

While Adobe takes their time to implement this 'idea', you can get around this design flaw by selecting all rows after filtering, right click and 'display only selected rows'. The column subtotal will then calculate correctly.

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,340 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,340 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived