Forum Discussion
Dynamic sumx () specific vales from a table
For my particular circumstance, I decided to add an extra column to the query by adding a line of multiple CASE WHEN functions to the sql query.
perezco Could you add a column for 'Quarter' that filters which conditions should be used each quarter?
Your intervention has made it much easier for me to see things in a more straightforward manner.😁
yes. I have the 'Quarter' column part of this fact table. 👍
perezco Glad the fog is clearing and it's getting easier - what questions do you still have outstanding? Or can we mark this post as solved?
Feel free to write up a summary of what you did and mark your own post as the solution if that makes the most sense. 🙂
For my particular circumstance, I decided to add an extra column to the query by adding a line of multiple CASE WHEN functions to the sql query.