Pie Chart - Problems creating chart from a related table
Ihave created a in List View that has a Part Defifnition - SubSummary when sorted by: 1.Name and 2.TypeOfTask. In the SubSummary I have a Pie Chart that work well with the sort, showing me the Type By Name. On the Same layout in the Part Defintion - Header I want to place another Pie Chart that will show me (in %) only the TypeOfTask. I know that if I change my sort for the Layout to be only: 1.TypeOfTask, this Pie Chart will display the data correctly. I would like to display both Charts at the same time. I duplicated the table in the Database and related them to eachother by ID. I am unable to "configure" the Pie Chart in the header to show me what i need. Please let me know if oyu have any suggestions. Thank you.