Hi Looking for a simple way to compare This Years Sales v Last Years Sales.In the table I have a measure "Sales" and a date dimension "Date" in the format of YMDI want to be able to display the variance in the table.In the table I will have sales and...
Hi I am struggling to create a YTD calculation in the model.I am using Classic ModelIn the formula box: YTD ([sales],[d/date])When adding the new measure to a table no data is displayed and I am getting the warning displayed below Dimension not foun...
Hi All
I want to schedule publication so that a report gets sent on specific days of the month. These being the 7th, 14th, 21st, 28th & the last day of the month this is for every month of the year.
Is this possible to do?
Hi all
I have the measure "Sales" and a dimension "Prod_Code".
I want to be able to create a measure where it returns the sales value of all products that begin with "Li".
I cant get it to work does anyone know how to do this?
Thanks
