Infopath functionality similar to pivot table or access group by

Last post 11-13-2014 10:12 AM by tplee. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

11-13-2014 10:05 AM

tplee
Joined on 06-05-2014
Posts 26

Infopath functionality similar to pivot table or access group by

Example Summary.jpg

Reply Contact

Hi all,

I'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.

anybody know a way to do this, im sort trying to use infopath like a dashboard for something

Thanks,

11-13-2014 10:12 AM In reply to

tplee
Joined on 06-05-2014
Posts 26

Re: Infopath functionality similar to pivot table or access group by

Mark as Not Answer Mark as Answer ...

Reply Contact

Just 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,

Page 1 of 1 (2 items)

InfoPath Dev