I have a field in main table like this :
The problem is, can I make a new field that contain a value from it ? For instance, I need field CountofSubmittedData, and the value will be the count of Submitted Data from the main table.
Thank you everyone
Solved! Go to Solution.
This may do the job:
Left Join (MasterTable)
,Count(Status) as StatusCount
Group by Status
Why do you avoid Count function in Chart type table?