问题描述
大家好，
我在详细级别使用sql代码创建了一个报告。我做了最低级别的计数（计数（productid）超过（按地点选择））
I created a report using a sql code at the detail level . I did counts at the lowest level ( count(productid) over(patition by location))
我添加了位置参数。所有工作正常，除了计数请参见附图，当我选择城市印第安纳波利斯和fortwayne在单独的迭代我相应的计数，但当我选择在这个例子中的所有城市forrtwayne
和印第安纳州polis 我期待看到的是
and i added the location parameters. All works fine except the count please see the attached image, when i select the cities indianapolis and fortwayne in seperate iterations iget the respective counts but when i select all cities in this example forrtwayne and indiana polis what i am expecting to see is
CARROT -119
CARROT -119
玉米 - 75
NH3 - 69
NH3 - 69
ETH -99
PM - 165
PM - 165
我隐藏了州和城市的字段，它们只是需要作为参数。请帮忙
I am hiding the fields state and city, they are just needed as parameters. please need help
谢谢
推荐答案
当我从所有参数中选择所有值时，我希望只看到一条记录。有什么建议吗？
I am expecting to see just one record when i select all values from all parameters. Any suggestions?
谢谢
这篇关于报告未汇总的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！