Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to display the count of Products on each month using a set analysis.
for example: Dec count in a column, November count in next column and oct count in next column.
Count({<[Products]={'$(=Date(Max(Date#([Month],'MMMM')),'MMMM'))'}>} [Products]) - Gives me December count
Count({<[Products]={'$(=Date(Max(Date#([Month],'MMMM'))-1,'MMMM'))'}>} [Products]) - Gives me Nov
countCount({<[Products]={'$(=Date(Max(Date#([Month],'MMMM'))-2,'MMMM'))'}>} [Products]) - returns null.
How to solve this?
Also I have 3 months(Dec, Nov & Oct) in a column, and I need to display the column name as DEc, Nov, OCt in 3 different columns. I ma not able to
Any suggestions please