@Pritul_Patel, as Aleks explained, we can't currently create a single value vis with pivoted data. The workaround in the meantime would be to unpivot the date field and use different functions in the table calcs. For example, if we have data in this format which we cannot visualize as a single value because it includes a pivot:
We can unpivot the week column and calculate the same metrics with different table calculations so that we can display the results as a single value:
If you're having trouble converting your particular calculations after removing the pivot, feel free to paste them here and we can help out. Or if you would prefer not to share them publicly you can shoot an email to email@example.com with the specific examples.