Sorting Expression Issue in Pivot table

[Anonymous]

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.

[MK_QSL]

Can you upload your sample apps?

[Christian_Lauritzen]

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

[Anonymous]

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.