Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have desined dashboard using more than 10 tables.
it is working fine,but i am facing one problem that when i have not selected any thing
all data in dashboard shows perfectlly but when i select manager name form selection box few rows of
few datatable's not available to show.
can any one suggest,that what are the situation when selecting any thing from slection box
impact table in dashboard.
HI,
It may not be easy to help you without understanding your data model.. but...
If you have an expression and you want to ignore a selection in a specific field (e.g. Field1), you can use set analysis.
For example, if your expression is sum ( VALUE) and you want to ignore selections in the field 'Field1', you can write the following new expression:
sum ( {<Field1 = >} Value)
You can ignore as many fields as you want:
Sum ( sum ( {<Field1 = , Field2>} Value)
If you want to ignore all selections you can use:
sum ( { 1} } Value)
Hope this helps,
Erich
HI,
It may not be easy to help you without understanding your data model.. but...
If you have an expression and you want to ignore a selection in a specific field (e.g. Field1), you can use set analysis.
For example, if your expression is sum ( VALUE) and you want to ignore selections in the field 'Field1', you can write the following new expression:
sum ( {<Field1 = >} Value)
You can ignore as many fields as you want:
Sum ( sum ( {<Field1 = , Field2>} Value)
If you want to ignore all selections you can use:
sum ( { 1} } Value)
Hope this helps,
Erich