I'd like to get a SUM total on each of these values. I tried using the Parent and = SUM as well as the pivot table.
When I try the pivot table it tells me I need to install office etc. I have office 365 installed and all modules.
Thanks
General Discussion
Comments
Hi John, A couple of ways: …
Hi John,
There are quite a few ways to do this (depending on the actual use-case):
HTH !
Pierre_Admin
IQ Designer
Cool. So, I found a way to…
Cool. So, I found a way to get the totals by making a PARENT record. I can't seem to group by a field now though. Is there a way to do this?
See attachment.
You can have both but using…
You can have both but using different displays (so not at the same time)
To group, ensure that the parent item is not shown, otherwise it gets in the way of grouping. There are many ways to achieve this. Do not hesitate to ask how (hoist filter, flat list view, changing the grid source and ensuring context parents are off, etc)