Comments
-
Would love it if this could happen! I just had to nonsensically pad a dashboard's "above-the-fold" so that the configuration and results sections remained apart on the ppt output (as only the results portion is client-facing), and it looks pretty ridiculous. Unless I am missing some other means to do this?
-
I think the main issue here is that there is no relationship established within your data other than row order. Without a column in your data that tells you that rows 1 & 2 relate to other, as do columns 3 & 4, etc, there is no "clean" way to resolve the problem. In this event, pairing rows as you've done in your answer,…
-
Here's a slightly different method using the Lag function in Rank and Window that avoids pivoting altogether. End result here in 3 steps: Create Row_Number, Product_Odd, and Sales fields via a formulas node as follows. This will have the end result of containing the product value in odd-numbered rows. We're also applying…
