Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThanks for the solution.
How did you calculate the values? The data type should be numeric to get the summation of Weekly Rates, but the Weekly Rate has data type V_String.
Done 😉
I'm not privy to formatting on the community but how do you create the spoiler drop down?
Really enjoyed this one! Does anyone have suggestions on maintaining the integrity of the column names and not allowing the Cross Tab function to separate values by an underscore? Love to hear your thoughts!