Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Field1 | 23 | 45435 | 45345 |
Field2 | 2343 | 34534 | 43534 |
Field3 | 2456 | 34534 | 34534 |
suppose this is my pivot table, when i'm selecting Field2 it will show like this
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Field2 | 2343 | 34534 | 43534 |
but i want all the fields if i select field2.
Hi,
while calculating your expression in pivot table ... make use of set analysis..
For example:
sum({<Header1=>}values)
replace Header1 with the actual field name.
HTH
Sushil
Have you tried Concat ?
yup I'm doing it but its not working,
how can i use concat to solve this problem,can you elaborate?
PFA..
U want it like this??
Hi:
Use system table.
Use $Field as dimension. The thing is that system data does not interact or filter with the data model, so you probably need something like a Report Generator.
salutes.
attached file is not loading
If you want not to filter that particular field, you can set an action. When that field is selected, unselect that field.
I got the point,but still not getting how to do it,
how will i create the action ?plz give me an example