InfoPath Dev

Dear All, Can you please help me to make a filter in Repeating table. Ex: in my form, i have 3 Row in Repeating table with Option Bill and No bill How can I make a filter with option Bill or Non Bill.

I've attached a sample form. Right click and save locally, then right click the saved file and select Design. Then you should be able to preview. This is just one option - in your original post, you attached an XML, not your XSN - so if you need help implementing in your XSN feel free to attach.

Dear Ms. Hilary, It's very helpful. You are supper woman. Thank for your support. I have another question. I try to make Sum TOTAL of 1 column. How can I got sum total of this column with Filter option. As I try but it only so the Full total. not total with filter.

Happy to help - here's my original form with a filtered subtotal.

Wonderful. Super!!!

Dear Ms. Hilary, Can you help me with one 1 condition. In your form, I want to make filter of SUM TOTAL by Type and Site. Can we do it? If yes, could you please help me. Thanks

I'm not sure I completely understand the question, but am attaching a sample with a table of distinct types & sites and subtotals for those. Hopefully it helps. :)

hi. i attached my real form. example: Project Assigned Column I select A B C with Bill or Non Bill so In project site I will Filter Project with Bill/ Non Bill+ Project Assigned .So the Total Hour will be rẽcalculate also

So - I just want to make sure I understand. You need help adding the project filter to the two Total fields, outlined in the screenshot?

Yes Madam

Try the attached copy.

HI Ms. Hilary. As you can see in the photo, total hours for 30 row is 184 - If I select Project assigned with LLM ( 3 row - 1Non Bill and 2 Bill) - After that, I click to Project Filter = Total hours should be Sum of 3 Rows = 24 - Then If I click to Bill of Project Filter, Bill Total hours should be 16 hours But in the form it still Sum all BILL hours . It's is not correct.

Ok - I'll get another copy uploaded later today with this fixed.

Hi . Can you help me? P

I think the formula just needed some parenthesis. This one seems to work the way you want.