Using If statements

[mparker123]

Good Afternoon All,

I am building a pivot table with the below fields

Dimensions: project_name, Full_Name

Expressions:

Sum(IF(DEPT='44840' and Full_Name<>'RF' and Full_Name<>'PT' and project_name<>'PMO IMS Pipeline',HOURS),

Sum(If(DEPT='44840' and epic_summary = 'Internal',HOURS))))

The problem I believe is that i have two fields project_name and epic_summary. Project name is the parent field to epic summary. example: project_name = xyz implementation, epic_summary = xyz credit, xyz internal, xyz traning.

All epic summaries roll up into the xyz implementation.

I want a pivot table that shows me all of the project_names and just one epic summary all in the same pivot table. I am using the above formula to achieve this but it does seem to work. i was wondering if anyone new how to make the above formula work.

[tmackay2015]

try:

Sum(

{

$<DEPT={'44840'},Full_Name-={'RF','PT'},project_name-={'PMO IMS Pipeline'}>

+

$<DEPT={'44840'},epic_summary={'Internal'}>

}

HOURS)

This puts all the filtering logic into set analysis and one expression.

I would also add the epic_summary  as a dimension in the pivot table.

What is currently (not) displaying in the pivot table that you want there?

[mparker123]

The one epic_summary that i want on the chart

[mparker123]

so i entered that in and that does show the proper hours however the name is showing as blank. Is there a way to make the name of the epic summary show up?

[tmackay2015]

epic_summary being the value 'Internal'
or some external selection?