Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
please consider the following tables :
T1
___________
F1 F2 F3
1 A A10
2 A A20
3 B B10
4 B B20
5 B B30
T2
_______
F1 F4
1 5
1 10
3 12
3 17
5 20
5 7
5 4
then i have a Straight Table Chart with F2 & F3 as dimensions and sum(F4) as expression. the result is :
F2 F3 sum(F4)
A A10 15
A A20 0
B B10 29
B B20 0
B B30 31
i need to have all values in F2 and F3, so i checked "Show All Values" for F3 and i get two rows with 0 for sum(F4).
but when i make a selection on F4, for example "17" the table shows like this:
F2 F3 sum(F4)
B B10 17
- A10 0
- A20 0
- B20 0
- B30 0
the result is logical, but as a customer need, i have to show the result as below:
F2 F3 sum(F4)
A A10 0
A A20 0
B B10 17
B B20 0
B B30 0
the sample qwv is attached with data and two straight tables in different states. i appreciate any help.
Best Regards
Peyman
Hi Peyman Azimabadi,
You can make one more expression and using set analysis make it unaffected by selections and then hide that column.
Please find the attached app.
Let me know, if any issue!
..
Ashutosh
any idea?!
Hi Peyman Azimabadi,
You can make one more expression and using set analysis make it unaffected by selections and then hide that column.
Please find the attached app.
Let me know, if any issue!
..
Ashutosh
Hi Ashutosh,
the example runs good and it looks to be the right way to do this. Thank you so much for answer. I will apply the method to my app and tell you the result.
Best Regards
Peyman
Hi Ashutosh,
i want to say that the method works good in my app and Thank you againe for your help.
Best Regards
Peyman
Thanks Peyman!
Best Regards,
Ashutosh