I have a quick question as Im not sure if this is possible to do. I hae attcahed a samplpe twbx file to illustrate what I am aiming to achieve.
I have createa pivot of my dimensions so I can coint the number of responses for each question per school. Howver I do need to ceate a calculation to show me the number of resspnses i.e. how many record which shold be about 21 and not 147 as shown in Sheet3, this is because its been pivoted. if i unpivot the field i have 21 participants but iif i pivot i will have 147. I need to show . so for example in my donut chart in Sheet2 totaol the middle should show 21 respondandat and the donut should show the % of the pivot field values for each scvhool or all the schools. I hope i am clear in what I want to achieve unless I am totally looking at tis in a wrong way
Is there any way I can show how many repsonded i.e. 21 and then use the pivot to anlayse the reposnses.
Thanks inadvance
@Frank Vahid Razaghzadeh Can you try below and use that in your donut chart:
SUM({Fixed :COUNT(IF [Pivot Field Names] = 'Q1' THEN [Pivot Field Values] END)})