Ignoring date dimension

[noman212]

Hi Community,

I am using a pivot table.

From there , i am using 3 dimensions.

Category

Date,

SKU,

from dimension i am using Date as a upper dimension in Pivot table chart.

I am using an expression to calculate Targets.

Targets is available only day 1 for each year.

like

1-Oct-2016 500

2-Oct-2016 0

3-Oct-2016 0

4-Oct-2016 0

5-Oct-2016 0

6-Oct-2016 0

7-Oct-2016 0

8-Oct-2016 0

But i want to show this on every day same targets  like,

1-Oct-2016 500

2-Oct-2016 500

3-Oct-2016 500

4-Oct-2016 500

5-Oct-2016 500

6-Oct-2016 500

7-Oct-2016 500

8-Oct-2016 500

currently its returning 0 against remaining dates.

please help me to show same targets on daily basis my expression is

SUM({<[Order Date],Day=,Flag={'SalesTarget'}>} Target_Cartons)

snapshot is attached

[rubenmarin]

Hi Noman, can you try using 'TOTAL'?:

SUM(TOTAL {<[Order Date],Day=,Flag={'SalesTarget'}>} Target_Cartons)

TOTAL is used to ignore chart dimensions but the selections still have effect. You can add fields to tell QV how to totalize but this has to fit with chart dimensions in a logical way:

SUM(TOTAL <jory> ....)

[noman212]

Thanks for your replyRuben.

Yes I tried but it return sum of field.

In sku field data is present in breakup this expression ignore the breakup value and club all sku in total.

[rubenmarin · Accepted solution]

Not sure to have understood this but... you tried also to set fields in TOTAL?, like:

SUM(TOTAL <jory, PAYSOFT_CODE, SKU> {<[Order Date],Day=,Flag={'SalesTarget'}>} Target_Cartons)

If not please give me more details about what you want and where you're stuck... my english is very limited, I can be more helpfull with a sample to work.

[noman212]

Thanks  a lot that's what i want.