Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I need help on my sort expressions in my pivot table...
I have a series of Monday dates in weekly buckets for the the current year and with '-' date (those transaction that happened before the current year ).
Category 12/30/13 01/06 /2014 01/13/2014 01/20/2014 02/07/2014 unitl 05/26/2014 -
PO 500 200 300
Order 5 15 20
Sales 200 300 200 200
Invtry 1000
1. How do I make the Category Inventory or those dates that are current like 2/7/2014 to make it to the 1st week bucket (before the 12/30/2013? I don't have a weekly data for the invtry since our source data is live....so it's always current
2. Since I have a null date where the transactions happened before the 2014, I want to exclude these in my pivot chart,
Tks.
Can you upload your sample apps?
Hi,
With reservation for that I might not completely grasp your challenge, but here is a try;
1. Sort dates in a custom order; Choose sort by expression under the sort tab and create an expression that put Category Inventory or those dates first. Cannot give you more that this as I have no more input. Could you submit your qvw and an excel doc showing your desired outcome?
2. Exclude Null Values - Simply check "Suppress when value is Null" on the Dimensions tab for the Date dimension
Hi! Christian,
Question no 2 actually worked ..For question no 1, I actually haven't tried using the sort expression...If you could provide me the formula that woul be better.
Tks.