Schedules: Sum of Grand Totals per Columns
Will adding a footer in the Sorting/Group tab for the items you are grouping by get you there?
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Enable calculations for the User parameter C so you'll get sub-totals for each group and and grand total at the bottom for that column too. I probably misunderstand what result you want.
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
I think I understand now. You want each row to show the result of dividing the total value at the bottom of the schedule for A and B. You can calculate across the row, A/B and show that value but not the result of math on the total of the column. I also don't understand how that provides a meaningful result for a single door?
I have seen people use the Percent of Total option to create occupancy calculations where they need to count things and provide a value that works back from the total of something to an individual calculation but I'm not certain that concept will work in this case. I'll post a link when I find the article I'm thinking of.
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
See if Tim's post on his BLOG here might work to get what you want.
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Separate schedules, filter each so you only include a single level and use the grand total?
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
