-
1. Re: Having a field containing grouped/ungrouped values?
Deepak RaiNov 19, 2018 9:04 PM (in response to Rafael Benavent)
- Self Union Your data Twice
- Write a Calculation
- Exclude Null and here it is:
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to close Thread
-
New_Dimension.twbx 11.3 KB
-
2. Re: Having a field containing grouped/ungrouped values?
Rafael Benavent Nov 20, 2018 3:14 PM (in response to Deepak Rai)Is there any way to do it without unioning the data? I imagine it would screw up all my other calculations (sum, count, etc.)
-
3. Re: Having a field containing grouped/ungrouped values?
Deepak RaiNov 20, 2018 4:05 PM (in response to Rafael Benavent)
Sorry..I am out of Ideas on this , but Have you tried the above and as You said your calculations went bad..I don't think so that happens.
-
4. Re: Having a field containing grouped/ungrouped values?
Peter Fakan Nov 20, 2018 4:08 PM (in response to Rafael Benavent)Hi Rafael,
You could do this with sets, but you could only display one set at a time due to the conflicts (i.e. a person who is IN the 7-12 group is also IN the Youth group).
I'm still not 100% sure of your requirement though, wouldn't this be better arranged as a separate column in your data ?
HTH
Peter
-
5. Re: Having a field containing grouped/ungrouped values?
Rafael Benavent Nov 20, 2018 4:21 PM (in response to Peter Fakan)Displaying one set at a time could be fine. How would I switch between different sets?
-
6. Re: Having a field containing grouped/ungrouped values?
Peter Fakan Nov 20, 2018 4:30 PM (in response to Rafael Benavent)With a parameter and a zinger of a calculated field
if [Parameter] = 1 then [Set 1]
if [Parameter] = 2 then [Set 2]
end
HTH
Peter