I have a data view web part which uses a "Linked Sources" as Datasource. I have created a master table, then created the joined subview inside the data view web part as usual. Instead of showing the detail data in the subview, I just showed the
number of rows as this is what I am interested in.
The master table is grouped by a specific column, so here is a representation of what I have:
FIELD_X FIELD_Z NUMBER(count of rows in the subview)
FIELD_Z FIELD_Z NUMBER
FOOTER_A (count of rows in the master table)
the count of rows in the subview is given by the following:
Now, in the footer I want to show the total count of rows of the subview , not the count of rows of the master table. How can I get the count of rows of the subview based on the grouping of the master table?
More specifically the problem is that the subview cannot be directly link to the group header; it can be joined to a field in the master table which must then be filtered based on the group header.
View Complete Post