Share
Report
28Not sure if this has been asked before, if it has I can not find it, so sorry for posting again.
I have a gallery which is filtered from another gallery. The filter is using the distinct function. I am trying to add a label into the gallery to show the number within the filter, but am having issues getting the syntax to work.
The gallery is displaying in room equipment and I want to show how many of each item there is within that room. For example the room would have 4 handheld microphones, the gallery filters and shows the distinct value of Handheld microphone, I need to add that there are 4 of them.
I have tried various combinations of syntax and am only getting error message. I have tried using CountRows with the distinct filter syntax used on the gallery, but it showing a total for all the items, not just the total for the items within the selected room. Any herlp advice pointers welcome. The equipment column is a value.
All responses (
Answers (
