How to add a Field Value

[Anonymous]

I have a field 'SIZE'  Currently It has values: Grande, Tall and Medium. Sometimes Small also gets added in the records for the same field. Req is to create a straight table that shows count of records by size. My question is how do I show  count for SIZE Small is equal

to zero when there are no records with 'Small' field value. Please help.

[sunny_talwar]

May be add a Inline Table Like this:

LOAD * Inline [

SIZE

Grande

Tall

Medium

Small

];

And then may be SIZE as dimension and Count({<UniqueIndetifier = {'*'}>}SIZE) and on the presentation tab may be uncheck 'Suppress When Zero'

[sunny_talwar]

Note: UniqueIndentifier needs to be a field which isn't null for the table where you have SIZE in. You would want to make sure to not use a field which can have null because then those nulls rows will be excluded.

[Anonymous]

Hi Sunny Thank you for your reply. I will post update soon