By using this website, you agree to our Terms of Use (click here)
I am trying to write a report in MYOB Advanced, Analytical Report Writer, that shows one node of a unit set in column B and a different node of the unit set in column C. This is best explained though pictures below.
I have tried using the Printing Groups in the Columns and the Unit Sets, but I can only get the report to show one part of the report at a time, depending on which section of the set is selected. i.e. I can show unit set 1 node in column B or unit set 2 node in column C, but I need them to show simultaneously.
The report is very similar to one that would show departments across the page, however I can't simply use a data source restriction on the column set as the departments are actually a number of non-continuous sub-departments (that are grouped together via the unit set).
Report to look like the following
Using Unit Sets to restrict column B and C, to only report that unit set
Hi Travis,
Hope you don't mind, but I updated your post and put the screenshots inline instead of in the original attachments.
I have tried to do this same thing, but wasn't able to figure out a way. The only way I know is messy. Basically define the departments that you want in the Data Source in separate hidden columns, then do a visible column that totals them up. Not pretty, but the only way I can think of at the moment unfortunately.