Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks a lot Sunny.
No problem
I am glad I was able to help.
Best,
Sunny