Combine Pivot tables to form a single report
Hi,
I have the need to combine two pivot tables in Zoho Creator. The pivot table report s are generated from the same Zoho table(Assignments). Pivot Table 1 is a summery of all tasks and income generated in a month. Pivot Table 2 shows the same data presented in more detailed way. Pivot Table two show a weekly breakdown of task and total income generated from those tasks.
I would like to combine those two pvot tables to form a single report with the summery report at the top and the more detailed table immediately at the bottom. I found a post with a similar question and the solution there was to use a HTML(embedded) view, however the end result is close but not what i am hoping to accomplish. The HTML view is able to combine both pivot tables, but there is a big gap in between Table1 and Table 2. Also , I'd like to be able to print the reprt, but all the zoho widgets are present in each table. My end goal is to get a combed and formatted report that is printable.
is thee a different approach?
Thank you.