Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 3 columns.
name Subject Marks
aa xx 20
aa yy 45
bb ee 33
No i want the count of marks which are <20, between 20 and 50,>50 for each student.
Regards
Hi,
try this.
=count({<marks={"<30"}>}name)
See the attach file.
Hi,
in 3 expression:
count({<Marks={"<20"}>}Name)
count({<Marks={">=20"}*Marks={"<=50"}>}Name)
count({<Marks={">50"}>}Name)
you can show this in pivot table for better understand.
See the attachment.
Thanks.
Narender
Try with this
count({<Marks={"<20"}>} Name)
count({<Marks={">=20<=50"} Name)
count({<Marks={">50"}>} Name)