Can you post the sample workbook ?
I know the count shows at the bottom left but how to show that count on Dashboard
when I place the worksheet on Dashboard the count wont display
for example in the above 615 rows how to display
I tried to create another sheet and removed all the fields and just left the filters but still not getting the correct count
2 of 2 people found this helpful
Okay I got your point try this. Just duplicate that sheet where you've all filters and records.
Let assume your sheet is just like that.
I've duplicated the above sheet and created a discrete calculated field using SIZE() and add a this field just before the Customer name dimension.
Now just hide the headers of Customer name and make the color of text to white of Sales measure. You'll have a view like this.
Now go to dashboard. Drag your Sheet1 as tiled and Count Sheet as floating. Manually resize that sheet so that only count part gets visible and fit the sheet as entire view. Like the below screen shot. And most important part make apply filters as global filters (Apply to all data source) or selected worksheets.
.Hope this help.
What if I have a different amount of "Marks" vs. Rows? SIZE() gives me the number of MARKS - not ROWS.