Filter Sum Based on Project Name

[#1]

Hi All,

Please find the attached Qvw. I have mentioned all the details in the Qvw.

I need to filter data based on P_name(Project name).

Current Value for Sum is below.

Num(

Sum({<FlagType={8},FiscalYearNo={"$(=max(FiscalYearNo))"},Level0={'Outflow'}>}Cashflow_Amount)

,

if(Sum({<FlagType={8},FiscalYearNo={"$(=max(FiscalYearNo))"}>}Cashflow_Amount)<0 and Level0='Inflow','#,##0;(#,##0)',

if(Dimensionality()=0 and Cashflow_Amount<0,'#,##0;(#,##0)','#,##0;#,##0'))

)

Here i need to add one more field P_name to filter Sum. SO that it displays only for P_name.

P_name is project name and it has 11 Projects.

Let me know if you need more details.

Thanks in advance.

Regards,

Keerthi KS

[sunny_talwar · Accepted solution]

You want to see your table to display like this?

I just selected 'Suppress When Value Is Null' on the Dimension tab of the chart properties:

I hope that this is what you were looking for?

Best,

Sunny

[#3]

Thanks a lot Sunny.

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny