Hi folks,
related to my earlier question over here I got a follow-up question:
In a straight table containing my root elements (cf. linked question with the great solution .qvw by Stefan) I need to display a column with the number of elements below this root.
Displaying this value by selecting root element and using a TextObject with the following expression works fine:
= COUNT({1<PID2 = P(NodeID)>} DISTINCT NodeID)
However, within the straight table this does not work, as I need to leave the scope of the current single row (to get to the other elements being related to the root). Therefore, I tried using TOTAL, but then NodeID in my Set Analysis is not anymore the current row's NodeID.
Is there a way to use TOTAL but still be able to use the NodeID of the respective row in the Set Analysis?
Any help is highly appreciated!