And here is the XLS file as mentioned in my message above. I think the Excel file better conveys the ultimate objective. Thanks! Mark
View Question
mgandy | Answers
Thanks, Rich! And that makes complete sense - I like your idea of pushing to SQL server.
View QuestionSimilar to SAU's great use of a filter, on the home page of the financials, I also employed a date filter that drives the trailing-12 month P&L. If you want to include these views in your reporting,...
View QuestionMy fault as I realized I misunderstood your question. And I cannot delete my original answer. You probably already know that you cannot use the timeline for this unless you collapsed the quarters you were...
View QuestionI prefer using the Timeline functionality. See the attached example which includes notes.
View QuestionWhat's the best way to approach Sau's formula where all Financial LineItem's are updated? I'd prefer not to enter this formula for each individual line item.
View QuestionThere are probably multiple ways to do this, but would be helpful to see the best or second-best way to use YTD when the budget column is fully populated as it normally would be.
View QuestionInstead of a pie chart, a bar chart would be more meaningful. In Tableau, a bar-within-a-bar chart is easy to pull off. I'm not very good with the chart builder in Quantrix, but the attached gives you...
View QuestionI thought about creating a new thread, but decided to use this one as it aptly applies and will make it easier for future searches if this same question arises. I'm using Version 6.4.1 and I'm having...
View QuestionThanks, Sau. I got it to work after posting my question. Here's what worked for me (without getting flagged): Percent to Revenue:Period = Actuals:Description/Actuals:Sales (which still didn't look right)...
View Question