Dashboard Summary report

SRINU V

Hi , I have some query

i have a share point list like master based on the list there are two column

1 . function

2 . status(1st,22nd,3rd)

i need function and status wise total count with dashboard .

Please help me urgent ..

Sample dashboard

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Thivagar Segar8y ago
Hi Srinu,

I am not sure about your requirement, based on your question i can understand that you want to calculate some column based on their values. if so, that you can do it by creating the required columns and add some caluculated column for Total Open and Total Closed.
and for sum you can change the view setting to sum the row values.

0
Nanddeep Nachan8y ago
Is there a possibility to use Power BI report in your case?
Power BI reporting will help you for pivoting.
0
Code Alone8y ago
Hi Srinu,

Use Pivot for the same. Below links will help you :

https://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server

https://www.youtube.com/watch?v=h3BtudZehuo
0