-
1. Re: Show filtered and unfiltered data side by side
Shawn Wallwork Jun 25, 2013 1:09 PM (in response to Noel Avison)Noel, I'm pretty sure that's going to be a second sheet displayed side-by-side in a dashboard (with all the unintended consequences).
--Shawn
-
2. Re: Show filtered and unfiltered data side by side
Noel Avison Jun 25, 2013 2:54 PM (in response to Shawn Wallwork)Well, the main problem with that is that the sort order won't be the same, and the machines that didn't run during that week will be in the year to date view... I guess the solution might be to add a total year to date yield number directly in the data.
-
3. Re: Show filtered and unfiltered data side by side
Shawn Wallwork Jun 25, 2013 5:32 PM (in response to Noel Avison)Yeah I know. Actually a friend mention to me off-forum that you could do what you want by duplicating your data source, then joining blending it back on itself using selective fields, that wouldn't filter your original data. Use filters from your original data source to build the view you've got. Then use fields and filters from the secondary source to get the totals you're looking for.
Hope this makes sense.
--Shawn
-
4. Re: Show filtered and unfiltered data side by side
Noel Avison Jun 25, 2013 4:08 PM (in response to Shawn Wallwork)