https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/100049.aspxThu, 13 Nov 2014 18:12:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100049tplee0https://www.infopathdev.com:443/forums/thread/100049.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=100049Just to add to this, I know how to get it to work for 1 ID but it only shows the first ID number that comes up, I cant get it to summarize for Multiple unique ID numbers thanks,https://www.infopathdev.com:443/forums/thread/100048.aspxThu, 13 Nov 2014 18:05:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100048tplee0https://www.infopathdev.com:443/forums/thread/100048.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=100048Hi all, <p>I&#39;m trying to make a summary table from a secondary data source similar to a pivot table in excel or grouping by in access. I have rows with the same ID numbers and diffrent costs and I would like to query all the data but summarize it like the following attached example. <p>anybody know a way to do this, im sort trying to use infopath like a dashboard for something <p>Thanks,