Forum Discussion
learner03
Post Partisan
Post PartisanColumns visual across report formating
I have few tables with dififfent data and all needs to be linked to give below sort of output. Please guide-
1)
Sales
Item
Month
Quantity
...
bolfri
Solution Sage
Solution SageCan you prepare an Excel file with the expected results so I can understand where do you want and do not want totals and some highlights? You can share here a screenshot of an idea, so I can understand what do you want to achive.
learner03Post Partisan
Post Partisanbolfri Please let me know if you can access this file. I have added calculated colums at the end for MOnth cover and Closing projection as a sample and the formulas are on the cells. There will be more calculated columns in addition but want to see how to add calculated clums in the output view. Also added the highlighting for months cover -if it is less than 5 then green and more than 10 then red. Also, if closing projection is negetive number than red.