Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have SQL table and it contains millions of records. I just want to get count of every gropy by values dynamically..
This i want using Chart-Straight Table.
For example, let us consider below is my table example.
Material.No Grade
101 A
102 B
103 C
101 C
101 A
110 D
110 A
104 F
103 M
etc..... .....
Final output would be and group by grade. so the count as below
A B C D F M
3 1 2 1 1 1
Note : The output will be always dynamic. some times it may add some more values. so want to get that count also.
pls. guide us how to get the count in Chart - Staright Table. This is important in my module and reply asap.
May be this
Dimension
Grade
Expression
Count([Material.No])
can i have sample page with example complete Scripts...
sample script? I am not sure I understand? Do you have an app where you are trying this? May be share that and we can update it to show how this can be done
@saivina2920 wrote:
Thanks for your help..
shall i directly call the below as you mentioned.
Dimension : Grade
Expression : Count([Material.No])
if i set the above expression, can i get the below report.
A B C D F M
3 1 2 1 1 1
I believe so
On the presentation tab, check 'Horizontal' to make it horizontal 🙂
Not sure I understand your question? Can you elaborate using an image?