Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hay All,
I Have a Complex Table In The UI with 50
Diffrents expression and dimmenssion situation
that the user can have
And I Need To Find how many line the table present (on text box for example)
with the most simply way to get it correctly (even with macro)
Best Regards
Lavi
Hay Marcus
Thank You Very much
For Your Replay
I will Do It With Complex Aggr Function
Best Regards
Lavi
I would say who creates a complex table shouldn't expect a simple way to count the rows there ...
Depending on the complexity a macro-solution might look as the easiest way but even there it might not trivial especially if there are visibility-conditions applied a simple row-count may not always work and more expensive and advanced approches might be necessary. Beside this you would need to ensure that this macro would be triggered by each user-action in the application and which may lead to side-effects. In general it's not recommended to use macros within the UI.
Therefore the way which I do recommend for it is to apply a distinct count of all used dimensions of the table. In the case that there are various set analysis used which may overwrite the applied selections and could therefore have an impact of the number of shown dimension-values you need to include them with the above mentioned count, too - and it could further mean that not a single count may be enough else you may need multiple ones within a range-function and/or some aggr() to consider all possibilities. See as a starting point my comment here:
Row-Count-Macros-not-working-in-Straight-table
In the end I suggest to simplify your approach especially by splitting the table into several ones with less complexity. Who wants and could really use such huge tables?
- Marcus
Hay Marcus
Thank You Very much
For Your Replay
I will Do It With Complex Aggr Function
Best Regards
Lavi