[RDL]中多行组列组占比报表制作

结果如下：

生意额占比表达式：=iif(Fields!生意额.Value is nothing,"",Fields!生意额.Value/sum(Fields!生意额.Value, "规模"))

数据源：

SELECT   '华南' AS 区域, '广东' AS 省份, '广州一店' AS 店铺, '100平方' AS 规模, 1000 AS 生意额

UNION

SELECT   '华南' AS 区域, '广西' AS 省份, '南宁一店' AS 店铺, '100平方' AS 规模, 8000 AS 生意额

UNION

SELECT   '华南' AS 区域, '广西' AS 省份, '南宁二店' AS 店铺, '200平方' AS 规模, 9000 AS 生意额

UNION

SELECT   '华中' AS 区域, '湖北' AS 省份, '武汉一店' AS 店铺, '50平方' AS 规模, 3000 AS 生意额

UNION

SELECT   '华中' AS 区域, '湖南' AS 省份, '长沙一店' AS 店铺, '50平方' AS 规模, 4000 AS 生意额

巴特西

[RDL]中多行组列组占比报表制作

最新文章

热门文章