Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
The one epic_summary that i want on the chart
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?
epic_summary being the value 'Internal'
or some external selection?