Issue in dimension

[ferha_jafri]

Hello Everyone,

I am attaching a sample data for my issue , my issue is that i  want to show those dimension for which the value of expression is greater than 0.

Thanks in advance

Ferha Jafri

[Anonymous]

Ferha

In your sample the expression is always greater than zero for every permutation of selections.

Is there something I a missing ?

[ferha_jafri]

In this i wrote 2 expression one for rows > 0 and other is the row total as user wants the weighted sum to be taken in the total not rows total , so i want to include 2 states for row >0 and all states for total ,so i m using this expression now i am the correct summation in total and row wise but the states which i don't want in from of them i am getting 0 although i don't want to show them.

[sudeepkm]

I've created an example using your data and showing Quantity by States.

One chart shows all States and another chart shows only those States where the Quantity is > 400.

You can change it as per your requirement.

[#5]

Hello Dear

Find Attachment for Solved Qvw file.

Regards

Asim

[ferha_jafri]

Hi Sudeep ,

The above expression is working fine for simple expression ,please check my expression , it is a bit complicated ,i am attaching the application again .Let me explain the expression to you what is happening in the expression is :

i am calculating as per the formula as 1-fabs(abs-forecast)/forecast this is am calculating row wise and in the total i am calculating the weighted of these values and total is independent of Brand desc.Please check.