How to add value to dimension

[Lucky1]

I have a dimension in my table 

Products

  Apple

   Orange

Banana

Measure count(id)

I want to add 'All products by count'

So my output will be like 

Product 

All products by count 3

Apple.                     1

Orange.                   1 

Banana.                   1

I have to add Dd in status

[Chanty4u]

Try this 

Dimension: Product

Measure: Count({1} Id)

[Lucky1]

Hi i want to show 'all products by count'  along with banana apple and in the measure i want to show the count(id)

[Chanty4u · Accepted solution]

Try this 

Products:

LOAD Product,

     count(ID) as Count

FROM YourDataSource

GROUP BY Product;

Concatenate(Products)

LOAD 'All products by count' as Product,

     count(ID) as Count

FROM YourDat

aSource;