senthil murugn
New Member
Our Project is having multiple divisions like mechanical, Schematics, SW Developer, testing etc..,
Each division is assigned with some N no of Tasks.
Task status is declared as follows
====================================
STATUS DevStatus VerifStatus
====== ========= ===========
100% Completed = Devloper status = 100% & Cross Verification person's status = 100%
Pending = Devloper status = 100% & Cross Verification person's status != 100%
In Progress = Devloper status < 100% & Cross Verification person's status != 100%
Not Yet Opened = Developer status = 0
Created a Pivot chart & Slicer in Sheet6,
Slices are Division, DevStatus, VerifStatus & Task ID
and based on selection(all slicer) Task ID slicer is displaying respective Task Id's perfectly.
Our requirement is count the no of TASK ID from Slicer_Task_ID under each cases with some formula like
=Function(find the number of Tasks actively selected)
With your website reference used
=CUBESETCOUNT(Slicer_Task_ID) but its returning N/A
IT would be thankful if you could help us to resolve the issue.
Please find the attached sheets.
Used Excel2019.
Thanks
Senthil M
Each division is assigned with some N no of Tasks.
Task status is declared as follows
====================================
STATUS DevStatus VerifStatus
====== ========= ===========
100% Completed = Devloper status = 100% & Cross Verification person's status = 100%
Pending = Devloper status = 100% & Cross Verification person's status != 100%
In Progress = Devloper status < 100% & Cross Verification person's status != 100%
Not Yet Opened = Developer status = 0
Created a Pivot chart & Slicer in Sheet6,
Slices are Division, DevStatus, VerifStatus & Task ID
and based on selection(all slicer) Task ID slicer is displaying respective Task Id's perfectly.
Our requirement is count the no of TASK ID from Slicer_Task_ID under each cases with some formula like
=Function(find the number of Tasks actively selected)
With your website reference used
=CUBESETCOUNT(Slicer_Task_ID) but its returning N/A
IT would be thankful if you could help us to resolve the issue.
Please find the attached sheets.
Used Excel2019.
Thanks
Senthil M