1 of 1 people found this helpful
This was a good one! I Enjoyed this!
Sunil, nice shot.
Hope you're holding Ctrl (cmd) key on the go :-)
The follow-up question is:
How did i get here (the first time)?
Why in the former the Dimension filter SIGN([Profit])
couldn't be applied to the DS / Selected Worksheets?
One would be reasonably expect it to be as in the latter.
Michael, you're welcome.
If we're talking about magic... no Ctrl key is needed (at least not on a 10.5 Windows platform). A direct drag-and-drop from Rows to Measures will populate the Measures with SIGN([Profit]) and keep it in the Rows. This behavior is a little different than when dropping it into Filters (where you need to hold down Ctrl or you risk losing it in Rows).
Maybe it's just good SOP to keep the Ctrl down?
By 'holding Ctrl' i only mean keeping the 'before-after' picture consistent
(not loosing the pill on Rows or on Filter -- whatever you move).
2 of 2 people found this helpful
Steps to get to SIGN([PROFIT])
- Click ROWS
- Type the calculation SIGN([PROFIT])
- When you [Enter], you'll have SUM(SIGN([PROFIT]), so right-click the green pill
- Change it to Dimension
- Right-click the pill that now reads SIGN([PROFIT])
- Change it to Discrete
- The pill is now blue and reads SIGN([PROFIT])
- You can Ctrl-Drag this onto Filters and hit [OK]
- Drag-and-drop [Profit] onto Text to populate with SUM(Profit)
Why can't it be applied to additional worksheets without some magic steps?
Hmm... I'm going to guess it's because initially, SIGN([PROFIT]) is a calculated field that isn't represented in the Data Source.
If we look at our original data source (before the Magic Move), we don't see SIGN([PROFIT]) present. We can toss any other dimension or measure onto the filter shelves and apply it to additional worksheets just fine.
Once we've made our Magic Move, Sign([Profit]) is turned into a measure: it appears in our Data Source and we can apply the filter it to other worksheets.
Data Source before Magic Move
Data Source after Magic Move
Was I close?
It's also good to realize that sign([Profit]) is simply the name of the calculation and-- while it is reflective of what the calculation is doing, one could rename this to whatever one wanted.
for the precise answer.
Closing the thread.